- 24 Nov, 2007 6 commits
-
-
Bruce Momjian authored
it is needed --- basically don't remember the previous 'search_path' after a drop schema because it might have failed but be created later.
-
Bruce Momjian authored
-
Bruce Momjian authored
if the locale has the thousands separator as "". This now matches the to_char and psql numericlocale behavior. (Previously this data type was basically useless for such setups.)
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
where rtoffset == 0. In that case there is no need to change Var nodes, and since filling in unset opfuncid fields is always safe, scribbling on the input tree to that extent is not objectionable. This brings the cost of this operation back down to what it was in 8.2 for simple queries. Per investigation of performance gripe from Guillaume Smet.
-
- 23 Nov, 2007 5 commits
-
-
Tom Lane authored
where the EquivalenceClass machinery is unable to deduce anything more from a simple "var = const" qual clause. There are probably some more cases where this could be done, but this seems to take care of most of the added overhead for simple queries. Per gripe from Guillaume Smet. In passing, fix a problem that was exposed by this change: reconsider_outer_join_clause and friends were passing the wrong relids to build_implied_join_equality, resulting in RestrictInfos with the wrong required_relids. This mistake was masked in typical cases since the bogus RestrictInfos would never have escaped from the EquivalenceClass machinery, but I think there might be corner cases involving "broken" ECs where there would have been a visible failure even without the new optimization. In any case the code was certainly not operating as intended.
-
Bruce Momjian authored
'ssymbol' as used in previous function.
-
Bruce Momjian authored
< * Prevent long-lived temporary tables from causing frozen-Xid advancement > * Prevent long-lived temporary tables from causing frozen-xid advancement > > The problem is that autovacuum cannot vacuum them to set frozen xids; > only the session that created them can do that. > > >
-
Alvaro Herrera authored
relying on stringinfo.c. This fixes a problem reported by Marko Kreen, but I didn't use his patch, per subsequent discussion.
-
Tatsuo Ishii authored
ItemPointerData.
-
- 22 Nov, 2007 6 commits
-
-
Tom Lane authored
opfuncid of an OpExpr initially, considering that it has the information at hand already. We'll still treat opfuncid as a cache rather than a guaranteed-valid value, but this change saves one more syscache lookup in the normal code path.
-
Tom Lane authored
OpExpr and related nodes. We're going to have to set the opfuncid of such nodes eventually (if we haven't already), so we might as well exploit the opportunity to cache the function OID. Buys back some of the extra planner overhead noted by Guillaume Smet, though I still need to fool with equivclass.c to really respond to that.
-
Bruce Momjian authored
-
Tom Lane authored
"bool" into plperl.c. This has always been a hazard since Perl allows a platform-specific choice to define bool as int rather than char, but evidently this didn't happen on any platform we support ... until OS X 10.5. Per report from Brandon Maust. Back-patch as far as 8.0 --- a bit arbitrary, but it seems unlikely anyone will be trying to port 7.x onto new platforms.
-
Bruce Momjian authored
-
Bruce Momjian authored
used.
-
- 21 Nov, 2007 5 commits
-
-
Bruce Momjian authored
(conflicting values).
-
Bruce Momjian authored
-
Bruce Momjian authored
so new thousands separator doesn't match decimal symbol.
-
Bruce Momjian authored
-
Tom Lane authored
-
- 20 Nov, 2007 15 commits
-
-
Tom Lane authored
happened to be right up against the end of memory, per report from Matt Magoffin. While at it, avoid useless multiple copying of string by not depending on xmlStrncatNew.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
-
Bruce Momjian authored
-
Bruce Momjian authored
release notes.
-
Bruce Momjian authored
-
Andrew Dunstan authored
Adjust contrib/tsearch2 regression results to use XML tag and XML entity descriptions, as now used by core text search default parser.
-
Bruce Momjian authored
-
Bruce Momjian authored
Re-order some items as migration changes.
-
Andrew Dunstan authored
Allow tag and entity names that follow XML rules. Provide for hexadecimal as well as decimal numeric entities. Adjust code names to coincide with new descriptions.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
< o Prevent COMMENT ON dbname from issuing a warning when loading < into a database with a different name, perhaps using COMMENT ON < CURRENT DATABASE > o Change pg_dump so that a comment on the dumped database is > applied to the loaded database, even if the database has a > different name. This will require new backend syntax, perhaps > COMMENT ON CURRENT DATABASE.
-
- 19 Nov, 2007 3 commits
-
-
Bruce Momjian authored
< o Allow COMMENT ON dbname to work when loading into a database < with a different name, perhaps using COMMENT ON CURRENT < DATABASE > o Prevent COMMENT ON dbname from issuing a warning when loading > into a database with a different name, perhaps using COMMENT ON > CURRENT DATABASE
-
Bruce Momjian authored
-
Bruce Momjian authored
< with a different name > with a different name, perhaps using COMMENT ON CURRENT > DATABASE >
-