[COMMITTERS] pgsql: Measure epoch of timestamp-without-time-zone from local not UTC

2012-04-10 Thread Tom Lane
Measure epoch of timestamp-without-time-zone from local not UTC midnight. This patch reverts commit 191ef2b407f065544ceed5700e42400857d9270f and thereby restores the pre-7.3 behavior of EXTRACT(EPOCH FROM timestamp-without-tz). Per discussion, the more recent behavior was misguided on a couple of

[COMMITTERS] pgsql: psql: Improve tab completion of WITH

2012-04-10 Thread Peter Eisentraut
psql: Improve tab completion of WITH Only match when WITH is the first word, as WITH may appear in many other contexts. Josh Kupershmidt Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/6b8c99c386d318b434829ac0c9ba935fb5e53d18 Modified Files -- src/bin/p

[COMMITTERS] pgsql: NLS: Initialize Project-Id-Version field by xgettext

2012-04-10 Thread Peter Eisentraut
NLS: Initialize Project-Id-Version field by xgettext Since xgettext provides options to do this now, we might as well use them. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/eb821b91c86a85a37572c9062902f94a5efba528 Modified Files -- src/nls-global.mk |

[COMMITTERS] pgsql: Fix pg_upgrade to properly upgrade a table that is stored in the

2012-04-10 Thread Bruce Momjian
Fix pg_upgrade to properly upgrade a table that is stored in the cluster default tablespace, but part of a database that is in a user-defined tablespace. Caused "file not found" error during upgrade. Per bug report from Ants Aasma. Backpatch to 9.1 and 9.0. Branch -- REL9_1_STABLE Details

[COMMITTERS] pgsql: Fix pg_upgrade to properly upgrade a table that is stored in the

2012-04-10 Thread Bruce Momjian
Fix pg_upgrade to properly upgrade a table that is stored in the cluster default tablespace, but part of a database that is in a user-defined tablespace. Caused "file not found" error during upgrade. Per bug report from Ants Aasma. Backpatch to 9.1 and 9.0. Branch -- master Details ---

[COMMITTERS] pgsql: Fix pg_upgrade to properly upgrade a table that is stored in the

2012-04-10 Thread Bruce Momjian
Fix pg_upgrade to properly upgrade a table that is stored in the cluster default tablespace, but part of a database that is in a user-defined tablespace. Caused "file not found" error during upgrade. Per bug report from Ants Aasma. Backpatch to 9.1 and 9.0. Branch -- REL9_0_STABLE Details

[COMMITTERS] pgsql: Make pg_tablespace_location(0) return the database's default tab

2012-04-10 Thread Tom Lane
Make pg_tablespace_location(0) return the database's default tablespace. This definition is convenient when applying the function to the reltablespace column of pg_class, since that's what zero means there; and it doesn't interfere with any other plausible use of the function. Per gripe from Bruce

Re: [COMMITTERS] pgsql: Make pg_tablespace_location(0) return the database's default tab

2012-04-10 Thread Bruce Momjian
On Wed, Apr 11, 2012 at 01:43:28AM +, Tom Lane wrote: > Make pg_tablespace_location(0) return the database's default tablespace. > > This definition is convenient when applying the function to the > reltablespace column of pg_class, since that's what zero means there; > and it doesn't interfer