- 19 Apr, 2009 1 commit
-
-
Tom Lane authored
etc are no longer guaranteed to produce sorted output; per gripe from Ian Barwick. Also improve the release note entries about to_timestamp(), per Brendan Jurd.
-
- 18 Apr, 2009 1 commit
-
-
Bruce Momjian authored
Support the <acronym>IS0 8601</> <type>interval</> syntax based on private email from Ron.
-
- 17 Apr, 2009 1 commit
-
-
Tom Lane authored
-
- 16 Apr, 2009 2 commits
-
-
Tom Lane authored
constants through full joins, as in select * from tenk1 a full join tenk1 b using (unique1) where unique1 = 42; which should generate a fairly cheap plan where we apply the constraint unique1 = 42 in each relation scan. This had been broken by my patch of 2008-06-27, which is now reverted in favor of a more invasive but hopefully less incorrect approach. That patch was meant to prevent incorrect extraction of OR'd indexclauses from OR conditions above an outer join. To do that correctly we need more information than the outerjoin_delay flag can provide, so add a nullable_relids field to RestrictInfo that records exactly which relations are nulled by outer joins that are underneath a particular qual clause. A side benefit is that we can make the test in create_or_index_quals more specific: it is now smart enough to extract an OR'd indexclause into the outer side of an outer join, even though it must not do so in the inner side. The old coding couldn't distinguish these cases so it could not do either.
-
Alvaro Herrera authored
Per note from Andrew Dunstan.
-
- 15 Apr, 2009 6 commits
-
-
Alvaro Herrera authored
-
Bruce Momjian authored
mentions in main documentation.
-
Alvaro Herrera authored
%s that they expand to, per comment from Tom.
-
Alvaro Herrera authored
-
Magnus Hagander authored
approval from Poul-Henning Kamp. This makes the file the same standard 2-clause BSD as the rest of PostgreSQL.
-
Bruce Momjian authored
-
- 14 Apr, 2009 5 commits
-
-
Tom Lane authored
select u&42 from table-with-a-u-column; Also fix missing SET_YYLLOC() in the {dolqfailed} production that I suppose this was based on. The latter is a pre-existing bug, but the only effect is to misplace the error cursor by one token, so probably not worth backpatching.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
-
Alvaro Herrera authored
previous patch. Per note from Tom.
-
- 13 Apr, 2009 2 commits
-
-
Alvaro Herrera authored
-
Tom Lane authored
-
- 12 Apr, 2009 1 commit
-
-
Andrew Dunstan authored
If a currently running item needs an exclusive lock on any item that the candidate items needs any sort of lock on, or vice versa, then the candidate item is not allowed to run now, and must wait till later.
-
- 11 Apr, 2009 9 commits
-
-
Tom Lane authored
tablespaces in an order that has some chance of working. Per a complaint from Kevin Bailey. This is a pre-existing bug, but given the lack of prior complaints I'm not sure it's worth back-patching. In most cases failure of the DROP commands wouldn't be that important anyway. In passing, fix syntax errors in dumpCreateDB()'s queries for old servers; these were apparently introduced in recent binary_upgrade patch.
-
Alvaro Herrera authored
-
Bruce Momjian authored
-
Peter Eisentraut authored
(I guess this was a cruise replace mistake.)
-
Peter Eisentraut authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 10 Apr, 2009 3 commits
-
-
Tom Lane authored
the plpgsql documentation about cursors. Per a suggestion from Matthew Wakeling.
-
Bruce Momjian authored
-
Marc G. Fournier authored
commit and tag beta1
-
- 09 Apr, 2009 9 commits
-
-
Tom Lane authored
-
Bruce Momjian authored
pg_stat_get_blocks_hit, per suggestion from Robert Haas.
-
Bruce Momjian authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Tom Lane authored
Argentina/San_Luis, Cuba, Jordan (historical correction only), Morocco, Palestine, Syria, Tunisia.
-
Peter Eisentraut authored
-
Tom Lane authored
-
Tom Lane authored
how this ought to behave for multi-dimensional arrays. Per discussion, not having it at all seems better than having it with what might prove to be the wrong behavior. We can always add it later when we have consensus on the correct behavior.
-