- 20 Apr, 2009 1 commit
-
-
Magnus Hagander authored
Hiroshi Inoue, with minor modifications by me
-
- 19 Apr, 2009 7 commits
-
-
Tom Lane authored
-
Tom Lane authored
fact that this is breaking the MSVC build, it's probably not really a good idea to expand the dependencies of gram.h any further than the core parser; for instance the value of SCONST might depend on which bison version you'd built with. Better to expose an additional call point in parser.c, so move what I had put into pl_funcs.c into parser.c. Also PGDLLIMPORT'ify the reference to standard_conforming_strings, per buildfarm results.
-
Tom Lane authored
encoded sequences. Per discussion of a couple of days ago.
-
Tom Lane authored
fields without putting a space between. Per gripe from Rick Schumeyer.
-
Tom Lane authored
Stefan Kaltenbrunner. The most reasonable behavior (at least for the near term) seems to be to ignore the PlaceHolderVar and examine its argument instead. In support of this, change the API of pull_var_clause() to allow callers to request recursion into PlaceHolderVars. Currently estimate_num_groups() is the only customer for that behavior, but where there's one there may be others.
-
Tom Lane authored
more nearly matching the core SQL scanner. The user-visible effects are: * Block comments (slash-star comments) now nest, as per SQL spec. * In standard_conforming_strings mode, backslash as the last character of a non-E string literal is now correctly taken as an ordinary character; formerly it was misinterpreted as escaping the ending quote. (Since the string also had to pass through the core scanner, this invariably led to syntax errors.) * Formerly, backslashes in the format string of RAISE were always treated as quoting the next character, regardless of mode. Now, they are ordinary characters with standard_conforming_strings on, while with it off, they introduce the same set of escapes as in the core SQL scanner. Also, escape_string_warning is now effective for RAISE format strings. These changes make RAISE format strings work just like any other string literal. This is implemented by copying and pasting a lot of logic from the core scanner. It would be a good idea to look into getting rid of plpgsql's scanner entirely in favor of using the core scanner. However, that involves more change than I can justify making during beta --- in particular, the core scanner would have to become re-entrant. In passing, remove the kluge that made the plpgsql scanner emit T_FUNCTION or T_TRIGGER as a made-up first token. That presumably had some value once upon a time, but now it's just useless complication for both the scanner and the grammar.
-
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 2 commits
-
-
Tom Lane authored
-
Bruce Momjian authored
pg_stat_get_blocks_hit, per suggestion from Robert Haas.
-