[COMMITTERS] pgsql: Simplify structure of query used to gather database object infor

2011-04-07 Thread Bruce Momjian
Simplify structure of query used to gather database object information in pg_upgrade. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e69d32158c18069840130f62c5597ca1ef656175 Modified Files -- contrib/pg_upgrade/info.c | 30 ++---

[COMMITTERS] pgsql: Preserve pg_largeobject_metadata.relfrozenxid in pg_upgrade.

2011-04-07 Thread Bruce Momjian
Preserve pg_largeobject_metadata.relfrozenxid in pg_upgrade. This is needed only in 9.1 because only 9.0 had this and no one is upgrading from a 9.0 beta to 9.0 anymore. We basically don't backpatch 9.0 beta fixes at this point. Branch -- master Details --- http://git.postgresql.org/pg/

[COMMITTERS] pgsql: Fix SortTocFromFile() to cope with lines that are too long for i

2011-04-07 Thread Tom Lane
Fix SortTocFromFile() to cope with lines that are too long for its buffer. The original coding supposed that a dump TOC file could never contain lines longer than 1K. The folly of that was exposed by a recent report from Per-Olov Esgard. We only really need to see the first dozen or two bytes of

[COMMITTERS] pgsql: Fix SortTocFromFile() to cope with lines that are too long for i

2011-04-07 Thread Tom Lane
Fix SortTocFromFile() to cope with lines that are too long for its buffer. The original coding supposed that a dump TOC file could never contain lines longer than 1K. The folly of that was exposed by a recent report from Per-Olov Esgard. We only really need to see the first dozen or two bytes of

[COMMITTERS] pgsql: Fix SortTocFromFile() to cope with lines that are too long for i

2011-04-07 Thread Tom Lane
Fix SortTocFromFile() to cope with lines that are too long for its buffer. The original coding supposed that a dump TOC file could never contain lines longer than 1K. The folly of that was exposed by a recent report from Per-Olov Esgard. We only really need to see the first dozen or two bytes of

[COMMITTERS] pgsql: Fix SortTocFromFile() to cope with lines that are too long for i

2011-04-07 Thread Tom Lane
Fix SortTocFromFile() to cope with lines that are too long for its buffer. The original coding supposed that a dump TOC file could never contain lines longer than 1K. The folly of that was exposed by a recent report from Per-Olov Esgard. We only really need to see the first dozen or two bytes of

[COMMITTERS] pgsql: Fix SortTocFromFile() to cope with lines that are too long for i

2011-04-07 Thread Tom Lane
Fix SortTocFromFile() to cope with lines that are too long for its buffer. The original coding supposed that a dump TOC file could never contain lines longer than 1K. The folly of that was exposed by a recent report from Per-Olov Esgard. We only really need to see the first dozen or two bytes of

[COMMITTERS] pgsql: Allow pg_upgrade with PGCLIENTENCODING set

2011-04-07 Thread Peter Eisentraut
Allow pg_upgrade with PGCLIENTENCODING set This used to work, but since PGCLIENTENCODING is now a connection option variable, pg_upgrade would prevent it. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/1eb2231fc46bbfa85b47c19d88f72162b323aa51 Modified Files ---

[COMMITTERS] pgsql: Fix plpgsql's issues with dropped columns in rowtypes in 8.4 bra

2011-04-07 Thread Tom Lane
Fix plpgsql's issues with dropped columns in rowtypes in 8.4 branch. This is a back-patch of commit dcb2bda9b7042dbf43f876c94ebf35d951de10e9 of Aug 6 2009, which fixed assorted cases in which plpgsql would fail to cope with composite types that contain any dropped columns. Per discussion, this fi

[COMMITTERS] pgsql: Modernize dlopen interface code for FreeBSD and OpenBSD.

2011-04-07 Thread Tom Lane
Modernize dlopen interface code for FreeBSD and OpenBSD. Remove the hard-wired assumption that __mips__ (and only __mips__) lacks dlopen in FreeBSD and OpenBSD. This assumption is outdated at least for OpenBSD, as per report from an anonymous 9.1 tester. We can perfectly well use HAVE_DLOPEN ins

[COMMITTERS] pgsql: Modernize dlopen interface code for FreeBSD and OpenBSD.

2011-04-07 Thread Tom Lane
Modernize dlopen interface code for FreeBSD and OpenBSD. Remove the hard-wired assumption that __mips__ (and only __mips__) lacks dlopen in FreeBSD and OpenBSD. This assumption is outdated at least for OpenBSD, as per report from an anonymous 9.1 tester. We can perfectly well use HAVE_DLOPEN ins

[COMMITTERS] pgsql: Modernize dlopen interface code for FreeBSD and OpenBSD.

2011-04-07 Thread Tom Lane
Modernize dlopen interface code for FreeBSD and OpenBSD. Remove the hard-wired assumption that __mips__ (and only __mips__) lacks dlopen in FreeBSD and OpenBSD. This assumption is outdated at least for OpenBSD, as per report from an anonymous 9.1 tester. We can perfectly well use HAVE_DLOPEN ins

[COMMITTERS] pgsql: Modernize dlopen interface code for FreeBSD and OpenBSD.

2011-04-07 Thread Tom Lane
Modernize dlopen interface code for FreeBSD and OpenBSD. Remove the hard-wired assumption that __mips__ (and only __mips__) lacks dlopen in FreeBSD and OpenBSD. This assumption is outdated at least for OpenBSD, as per report from an anonymous 9.1 tester. We can perfectly well use HAVE_DLOPEN ins

[COMMITTERS] pgsql: Modernize dlopen interface code for FreeBSD and OpenBSD.

2011-04-07 Thread Tom Lane
Modernize dlopen interface code for FreeBSD and OpenBSD. Remove the hard-wired assumption that __mips__ (and only __mips__) lacks dlopen in FreeBSD and OpenBSD. This assumption is outdated at least for OpenBSD, as per report from an anonymous 9.1 tester. We can perfectly well use HAVE_DLOPEN ins

[COMMITTERS] pgsql: Tweaks for SSI out-of-shared memory behavior.

2011-04-07 Thread Robert Haas
Tweaks for SSI out-of-shared memory behavior. If we call hash_search() with HASH_ENTER, it will bail out rather than return NULL, so it's redundant to check for NULL again in the caller. Thus, in cases where we believe it's impossible for the hash table to run out of slots anyway, we can simplify

[COMMITTERS] pgsql: Avoid use of mixed slash style paths in arguments to xcopy in MS

2011-04-07 Thread Andrew Dunstan
Avoid use of mixed slash style paths in arguments to xcopy in MSVC builds. Some versions of xcopy, notably on Windows 7 don't like it. Backpatch to 8.3, where we first used xcopy. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a53112338c2f5b74383ce075fbec098cd06a3ad

[COMMITTERS] pgsql: Avoid use of mixed slash style paths in arguments to xcopy in MS

2011-04-07 Thread Andrew Dunstan
Avoid use of mixed slash style paths in arguments to xcopy in MSVC builds. Some versions of xcopy, notably on Windows 7 don't like it. Backpatch to 8.3, where we first used xcopy. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/a5c629f373a8125cd7682083a290fff4

[COMMITTERS] pgsql: Avoid use of mixed slash style paths in arguments to xcopy in MS

2011-04-07 Thread Andrew Dunstan
Avoid use of mixed slash style paths in arguments to xcopy in MSVC builds. Some versions of xcopy, notably on Windows 7 don't like it. Backpatch to 8.3, where we first used xcopy. Branch -- REL8_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/5fe33744432f7509a07bccef51d07be6

[COMMITTERS] pgsql: Avoid use of mixed slash style paths in arguments to xcopy in MS

2011-04-07 Thread Andrew Dunstan
Avoid use of mixed slash style paths in arguments to xcopy in MSVC builds. Some versions of xcopy, notably on Windows 7 don't like it. Backpatch to 8.3, where we first used xcopy. Branch -- REL8_3_STABLE Details --- http://git.postgresql.org/pg/commitdiff/502ff05209ad08c50eb4f7ef491ff4d8

[COMMITTERS] pgsql: Fix some sloppiness in new PL/python get_source_line() function.

2011-04-07 Thread Robert Haas
Fix some sloppiness in new PL/python get_source_line() function. Jan UrbaƄski Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/b6bc481d5540a3ad0d39db1e9881e6bd52e54213 Modified Files -- src/pl/plpython/plpython.c | 11 +-- 1 files changed, 5 inse