[COMMITTERS] pgbulkload - pgbulkload: Bump up version to 3.1.2

2012-09-03 Thread User Sakamotomsh
Log Message: --- Bump up version to 3.1.2 Tags: VERSION3_1_STABLE Modified Files: -- pgbulkload/bin: postgresql (r1.14.2.1 -> r1.14.2.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbulkload/pgbulkload/bin/postgresql?r1=1.14.2.1&r2=1.14.2.2) pgb

[COMMITTERS] pgbulkload - pgbulkload: Updated regression tests for pgbulkload 3.1.2

2012-09-03 Thread User Sakamotomsh
Log Message: --- Updated regression tests for pgbulkload 3.1.2 Tags: VERSION3_1_STABLE Modified Files: -- pgbulkload/bin: Makefile (r1.17 -> r1.17.2.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbulkload/pgbulkload/bin/Makefile?r1=1.17&r2=1.17.2.1

[COMMITTERS] pgsql: Make psql's \d+ show reloptions for all relkinds.

2012-09-03 Thread Tom Lane
Make psql's \d+ show reloptions for all relkinds. Formerly it would only show them for relkinds 'r' and 'f' (plain tables and foreign tables). However, as of 9.2, views can also have reloptions, namely security_barrier. The relkind restriction seems pointless and not at all future-proof, so just

[COMMITTERS] pgsql: Make psql's \d+ show reloptions for all relkinds.

2012-09-03 Thread Tom Lane
Make psql's \d+ show reloptions for all relkinds. Formerly it would only show them for relkinds 'r' and 'f' (plain tables and foreign tables). However, as of 9.2, views can also have reloptions, namely security_barrier. The relkind restriction seems pointless and not at all future-proof, so just

[COMMITTERS] pgsql: Fix pg_upgrade to cope with non-default unix_socket_directory sc

2012-09-03 Thread Tom Lane
Fix pg_upgrade to cope with non-default unix_socket_directory scenarios. When starting either an old or new postmaster, force it to place its Unix socket in the current directory. This makes it even harder for accidental connections to occur during pg_upgrade, and also works around some scenarios

[COMMITTERS] pgsql: Back-patch recent pg_upgrade fixes into 9.2.

2012-09-03 Thread Tom Lane
Back-patch recent pg_upgrade fixes into 9.2. This syncs contrib/pg_upgrade in the 9.2 branch with HEAD, except for the HEAD changes related to converting XLogRecPtr to 64-bit int. It includes back-patching these commits: 666d494d19dbd5dc7a177709a2f7069913f8ab89 pg_upgrade: abstract out copying o

[COMMITTERS] pgsql: Fix bugs in exec.c that prevented pg_upgrade working in Windows.

2012-09-03 Thread Andrew Dunstan
Fix bugs in exec.c that prevented pg_upgrade working in Windows. Backpatch to 9.2 - code before that is quite different and should not have these defects. Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/c879e82b3746150171fcec605a6d5b2b21e5c6cf Modified Files

[COMMITTERS] pgsql: Fix bugs in exec.c that prevented pg_upgrade working in Windows.

2012-09-03 Thread Andrew Dunstan
Fix bugs in exec.c that prevented pg_upgrade working in Windows. Backpatch to 9.2 - code before that is quite different and should not have these defects. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/6259678f8f5443e9d396e20418448b247c6948dd Modified Files ---

[COMMITTERS] pgsql: Replace memcpy() calls in xlog.c critical sections with struct a

2012-09-03 Thread Tom Lane
Replace memcpy() calls in xlog.c critical sections with struct assignments. This gets rid of a dangerous-looking use of the not-volatile XLogCtl pointer in a couple of spinlock-protected sections, where the normal coding rule is that you should only access shared memory through a pointer-to-volati

[COMMITTERS] pgsql: Use correct path separator for Windows builtin commands.

2012-09-03 Thread Andrew Dunstan
Use correct path separator for Windows builtin commands. pg_upgrade produces a platform-specific script to remove the old directory, but on Windows it has not been making sure that the paths it writes as arguments for rmdir and del use the backslash path separator, which will cause these scripts t

[COMMITTERS] pgsql: Use correct path separator for Windows builtin commands.

2012-09-03 Thread Andrew Dunstan
Use correct path separator for Windows builtin commands. pg_upgrade produces a platform-specific script to remove the old directory, but on Windows it has not been making sure that the paths it writes as arguments for rmdir and del use the backslash path separator, which will cause these scripts t

[COMMITTERS] pgsql: Use correct path separator for Windows builtin commands.

2012-09-03 Thread Andrew Dunstan
Use correct path separator for Windows builtin commands. pg_upgrade produces a platform-specific script to remove the old directory, but on Windows it has not been making sure that the paths it writes as arguments for rmdir and del use the backslash path separator, which will cause these scripts t

[COMMITTERS] pgsql: Use correct path separator for Windows builtin commands.

2012-09-03 Thread Andrew Dunstan
Use correct path separator for Windows builtin commands. pg_upgrade produces a platform-specific script to remove the old directory, but on Windows it has not been making sure that the paths it writes as arguments for rmdir and del use the backslash path separator, which will cause these scripts t

[COMMITTERS] pgsql: In pg_upgrade, pull the port number from postmaster.pid, like we

2012-09-03 Thread Bruce Momjian
In pg_upgrade, pull the port number from postmaster.pid, like we do for socket location. Also, prevent putting the socket in the current directory for pre-9.1 servers in live check and non-live check mode, because pre-9.1 pg_ctl -w can't handle it. Backpatch to 9.2. Branch -- REL9_2_STABLE

[COMMITTERS] pgsql: In pg_upgrade, pull the port number from postmaster.pid, like we

2012-09-03 Thread Bruce Momjian
In pg_upgrade, pull the port number from postmaster.pid, like we do for socket location. Also, prevent putting the socket in the current directory for pre-9.1 servers in live check and non-live check mode, because pre-9.1 pg_ctl -w can't handle it. Backpatch to 9.2. Branch -- master Details

[COMMITTERS] pgsql: Allow pg_upgrade "make check" to run on Windows/MSys.

2012-09-03 Thread Andrew Dunstan
Allow pg_upgrade "make check" to run on Windows/MSys. Backpatch to 9.2. Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/765b5c41ba70098086988b4c7ba84162cd88e1de Modified Files -- contrib/pg_upgrade/test.sh | 19 +-- 1 files change

[COMMITTERS] pgsql: Allow pg_upgrade "make check" to run on Windows/MSys.

2012-09-03 Thread Andrew Dunstan
Allow pg_upgrade "make check" to run on Windows/MSys. Backpatch to 9.2. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e442b0f0c6fd26738bafdeb5222511b586dfe4b9 Modified Files -- contrib/pg_upgrade/test.sh | 19 +-- 1 files changed, 17 i

[COMMITTERS] pgsql: Fix to_date() and to_timestamp() to allow specification of the d

2012-09-03 Thread Bruce Momjian
Fix to_date() and to_timestamp() to allow specification of the day of the week via ISO or Gregorian designations. The fix is to store the day-of-week consistently as 1-7, Sunday = 1. Fixes bug reported by Marc Munro Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/01

[COMMITTERS] pgsql: Unbreak Windows builds on 9.0 broken by 4397c51816cbb918fc3aebc4

2012-09-03 Thread Andrew Dunstan
Unbreak Windows builds on 9.0 broken by 4397c51816cbb918fc3aebc474dd53bc231502b9. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/e62ad18663f0fcc37f9b4628bd244398b61aee67 Modified Files -- contrib/pg_upgrade/check.c | 19 ++- 1 fi

[COMMITTERS] pgsql: Indent fix_path_separator() header properly.

2012-09-03 Thread Andrew Dunstan
Indent fix_path_separator() header properly. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2f0c7d585412e0c061cb1cd8c2c0a4b6aada4f74 Modified Files -- contrib/pg_upgrade/check.c |3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) -- Sent via p

[COMMITTERS] pgsql: Indent fix_path_separator() header properly.

2012-09-03 Thread Andrew Dunstan
Indent fix_path_separator() header properly. Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/b5d437c011e9d739b79aa37ca19baca56b334ab7 Modified Files -- contrib/pg_upgrade/check.c |3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) -- Sen

[COMMITTERS] pgsql: Indent fix_path_separator() header properly.

2012-09-03 Thread Andrew Dunstan
Indent fix_path_separator() header properly. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/a69b7a1c34750f37c72acaac941555c70050dc7d Modified Files -- contrib/pg_upgrade/check.c |3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) -- Sen