- 12 Feb, 2009 2 commits
-
-
Bruce Momjian authored
-
Magnus Hagander authored
as this seems to crash on at least some versions of MingW. Our current usage of this function does not require it, so it should be ok to ignore.
-
- 11 Feb, 2009 5 commits
-
-
Tom Lane authored
get rid of the OID column. This eliminates the problem discovered by Heikki back in November that 8.4's suppression of "unnecessary" junk filtering in INSERT/SELECT could lead to an Assert failure, or storing of oids into a table that shouldn't have them if Asserts are off. While that particular problem could have been solved in other ways, it seems likely to be just a forerunner of things to come if we continue to allow tables to contain rows that disagree with the pg_class.relhasoids setting. It's better to make this operation slow than to sacrifice performance or risk bugs in more common code paths. Also, add ALTER TABLE SET WITH OIDS to rewrite the table to add oids. This was a bit more controversial, but in view of the very small amount of extra code needed given the current ALTER TABLE infrastructure, it seems best to eliminate the asymmetry in features.
-
Tom Lane authored
on AIX with a non-gcc compiler. The previous coding would do this only if CC was exactly "xlc"; which is a bad idea, as demonstrated by trouble report from Mihai Criveti.
-
Alvaro Herrera authored
ITAGAKI Takahiro.
-
Peter Eisentraut authored
presumably designed, but didn't act). This allows running the temp install tests in a non-C locale, thus exercising users' real environments better. Document how to change locales for test runs.
-
Bruce Momjian authored
-
- 10 Feb, 2009 4 commits
-
-
Peter Eisentraut authored
-
Peter Eisentraut authored
make maintenance harder.
-
Peter Eisentraut authored
arguments.
-
Bruce Momjian authored
collection.
-
- 09 Feb, 2009 3 commits
-
-
Tom Lane authored
contents of hash indexes (again), so bump catversion. Kenneth Marshall
-
Alvaro Herrera authored
per-table overrides of parameters. This removes a whole class of problems related to misusing the catalog, and perhaps more importantly, gives us pg_dump support for the parameters. Based on a patch by Euler Taveira de Oliveira, heavily reworked by me.
-
Bruce Momjian authored
Erik Rijkers
-
- 08 Feb, 2009 1 commit
-
-
Tom Lane authored
from the source table. This could never happen anyway before 8.4 because the executor invariably applied a "junk filter" to rows due to be inserted; but now that we skip doing that when it's not necessary, the case can occur. Problem noted 2008-11-27 by KaiGai Kohei, though I misunderstood what he was on about at the time (the opacity of the patch he proposed didn't help).
-
- 07 Feb, 2009 10 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
btree; keep mention about missing WAL logging. Kenneth Marshall
-
Bruce Momjian authored
-
Bruce Momjian authored
first. Alvaro Herrera
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
bit more visibility to the PGOPTIONS environment variable supported by libpq. Bryce Nesbitt
-
Bruce Momjian authored
designations (AM/PM). Also separate out matching of a meridian with periods (e.g. A.M.) and with those without. Do the same for AD/BC. Brendan Jurd
-
Heikki Linnakangas authored
-
Peter Eisentraut authored
-
- 06 Feb, 2009 5 commits
-
-
Tom Lane authored
keys when considering a semi or anti join. This requires estimating the selectivity of the merge qual as though it were a regular inner join condition. To allow caching both that and the real outer-join-aware selectivity, split RestrictInfo.this_selec into two fields. This fixes one of the problems reported by Kevin Grittner.
-
Tom Lane authored
-
Tom Lane authored
has_column_privilege and has_any_column_privilege SQL functions; fix the information_schema views that are supposed to pay attention to column privileges; adjust pg_stats to show stats for any column you have select privilege on; and fix COPY to allow copying a subset of columns if the user has suitable per-column privileges for all the columns. To improve efficiency of some of the information_schema views, extend the has_xxx_privilege functions to allow inquiring about the OR of a set of privileges in just one call. This is just exposing capability that already existed in the underlying aclcheck routines. In passing, make the information_schema views report the owner's own privileges as being grantable, since Postgres assumes this even when the grant option bit is not set in the ACL. This is a longstanding oversight. Also, make the new has_xxx_privilege functions for foreign data objects follow the same coding conventions used by the older ones. Stephen Frost and Tom Lane
-
Bruce Momjian authored
-
Bruce Momjian authored
Andrew Chernow
-
- 05 Feb, 2009 3 commits
-
-
Bruce Momjian authored
statement Pavel Stehule
-
Michael Meskes authored
-
Tom Lane authored
the cheapest-total inner path as a new candidate while truncating the sort key list, if it already matched the full sort key list. This is too much of a corner case to be worth back-patching, since it's unusual for the cheapest total path to be sorted, and anyway no real harm is done (except in JOIN_SEMI/ANTI cases where cost_mergejoin is a bit broken at the moment). But it wasn't behaving as intended, so fix it. Noted while examining a test case from Kevin Grittner. This error doesn't explain his issue, but it does explain why "set enable_seqscan = off" seemed to reproduce it for me.
-
- 04 Feb, 2009 3 commits
-
-
Alvaro Herrera authored
-
Bruce Momjian authored
behavior of concurrent commands in cases where rows are being added and removed from matching query criteria. Minor word-smithing.
-
Michael Meskes authored
-
- 03 Feb, 2009 4 commits
-
-
Michael Meskes authored
-
Michael Meskes authored
-
Andrew Dunstan authored
-
Tom Lane authored
unnecessary thread address output parameter, to make this code look more like that in pg_restore.
-