[COMMITTERS] pgsql: Update SQL features list

2015-09-11 Thread Peter Eisentraut
Update SQL features list Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/b2ae8f1e35d85e4e24a724ef64c47deb126368f7 Modified Files -- src/backend/catalog/sql_features.txt |9 - 1 file changed, 4 insertions(+), 5 deletions(-) -- Sent via pgsql-

[COMMITTERS] pgsql: Update SQL features list

2015-09-11 Thread Peter Eisentraut
Update SQL features list Branch -- REL9_5_STABLE Details --- http://git.postgresql.org/pg/commitdiff/d96c80c1d6f513f0588a19af8a00f4df9eba7837 Modified Files -- src/backend/catalog/sql_features.txt |9 - 1 file changed, 4 insertions(+), 5 deletions(-) -- Sent via

Re: [COMMITTERS] pgsql: Further fixes for degenerate outer join clauses.

2015-09-11 Thread Peter Eisentraut
On 8/6/15 3:36 PM, Tom Lane wrote: > Further fixes for degenerate outer join clauses. The <=9.2 versions of this change introduce a new compiler warning: variable ‘unique_ified’ set but not used [-Wunused-but-set-variable] This variable is apparently only used in 9.3+ for some LATERAL stuff,

[COMMITTERS] pgsql: Install lwlocknames.h even in vpath builds.

2015-09-11 Thread Robert Haas
Install lwlocknames.h even in vpath builds. Per buildfarm member crake. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a7212a9997e592fe72e2095a5f4f37071787d849 Modified Files -- src/include/Makefile |2 +- 1 file changed, 1 insertion(+), 1 deletion(-

[COMMITTERS] pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves

2015-09-11 Thread Bruce Momjian
pg_dump, pg_upgrade: allow postgres/template1 tablespace moves Modify pg_dump to restore postgres/template1 databases to non-default tablespaces by switching out of the database to be moved, then switching back. Also, to fix potentially cases where the old/new tablespaces might not match, fix pg

[COMMITTERS] pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves

2015-09-11 Thread Bruce Momjian
pg_dump, pg_upgrade: allow postgres/template1 tablespace moves Modify pg_dump to restore postgres/template1 databases to non-default tablespaces by switching out of the database to be moved, then switching back. Also, to fix potentially cases where the old/new tablespaces might not match, fix pg

[COMMITTERS] pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves

2015-09-11 Thread Bruce Momjian
pg_dump, pg_upgrade: allow postgres/template1 tablespace moves Modify pg_dump to restore postgres/template1 databases to non-default tablespaces by switching out of the database to be moved, then switching back. Also, to fix potentially cases where the old/new tablespaces might not match, fix pg

[COMMITTERS] pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves

2015-09-11 Thread Bruce Momjian
pg_dump, pg_upgrade: allow postgres/template1 tablespace moves Modify pg_dump to restore postgres/template1 databases to non-default tablespaces by switching out of the database to be moved, then switching back. Also, to fix potentially cases where the old/new tablespaces might not match, fix pg

[COMMITTERS] pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves

2015-09-11 Thread Bruce Momjian
pg_dump, pg_upgrade: allow postgres/template1 tablespace moves Modify pg_dump to restore postgres/template1 databases to non-default tablespaces by switching out of the database to be moved, then switching back. Also, to fix potentially cases where the old/new tablespaces might not match, fix pg

[COMMITTERS] pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves

2015-09-11 Thread Bruce Momjian
pg_dump, pg_upgrade: allow postgres/template1 tablespace moves Modify pg_dump to restore postgres/template1 databases to non-default tablespaces by switching out of the database to be moved, then switching back. Also, to fix potentially cases where the old/new tablespaces might not match, fix pg

[COMMITTERS] pgsql: pg_dump, pg_upgrade: allow postgres/template1 tablespace moves

2015-09-11 Thread Bruce Momjian
pg_dump, pg_upgrade: allow postgres/template1 tablespace moves Modify pg_dump to restore postgres/template1 databases to non-default tablespaces by switching out of the database to be moved, then switching back. Also, to fix potentially cases where the old/new tablespaces might not match, fix pg

[COMMITTERS] pgsql: Fix build problems in commit aa65de042f5828968f2f6cd65f45c543a40

2015-09-11 Thread Robert Haas
Fix build problems in commit aa65de042f5828968f2f6cd65f45c543a40cc3e6. The previous way didn't work for vpath builds, and make distprep was busted too. Reported off-list by Andres Freund. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2ccc4e972eb85829a8fe8d39fc5ce4

[COMMITTERS] pgsql: Add missing ReleaseBuffer call in BRIN revmap code

2015-09-11 Thread Alvaro Herrera
Add missing ReleaseBuffer call in BRIN revmap code I think this particular branch is actually dead, but the analysis to prove that is not trivial, so instead take the weasel way. Reported by Jinyu Zhang Backpatch to 9.5, where BRIN was introduced. Branch -- REL9_5_STABLE Details --- htt

[COMMITTERS] pgsql: Add missing ReleaseBuffer call in BRIN revmap code

2015-09-11 Thread Alvaro Herrera
Add missing ReleaseBuffer call in BRIN revmap code I think this particular branch is actually dead, but the analysis to prove that is not trivial, so instead take the weasel way. Reported by Jinyu Zhang Backpatch to 9.5, where BRIN was introduced. Branch -- master Details --- http://git

[COMMITTERS] pgsql: Fix an O(N^2) problem in foreign key references.

2015-09-11 Thread Kevin Grittner
Fix an O(N^2) problem in foreign key references. Commit 45ba424f improved foreign key lookups during bulk updates when the FK value does not change. When restoring a schema dump from a database with many (say 100,000) foreign keys, this cache would grow very big and every ALTER TABLE command was

[COMMITTERS] pgsql: Fix an O(N^2) problem in foreign key references.

2015-09-11 Thread Kevin Grittner
Fix an O(N^2) problem in foreign key references. Commit 45ba424f improved foreign key lookups during bulk updates when the FK value does not change. When restoring a schema dump from a database with many (say 100,000) foreign keys, this cache would grow very big and every ALTER TABLE command was

[COMMITTERS] pgsql: Fix an O(N^2) problem in foreign key references.

2015-09-11 Thread Kevin Grittner
Fix an O(N^2) problem in foreign key references. Commit 45ba424f improved foreign key lookups during bulk updates when the FK value does not change. When restoring a schema dump from a database with many (say 100,000) foreign keys, this cache would grow very big and every ALTER TABLE command was

[COMMITTERS] pgsql: Fix an O(N^2) problem in foreign key references.

2015-09-11 Thread Kevin Grittner
Fix an O(N^2) problem in foreign key references. Commit 45ba424f improved foreign key lookups during bulk updates when the FK value does not change. When restoring a schema dump from a database with many (say 100,000) foreign keys, this cache would grow very big and every ALTER TABLE command was

[COMMITTERS] pgsql: When trace_lwlocks is used, identify individual lwlocks by name.

2015-09-11 Thread Robert Haas
When trace_lwlocks is used, identify individual lwlocks by name. Naming the individual lwlocks seems like something that may be useful for other types of debugging, monitoring, or instrumentation output, but this commit just implements it for the specific case of trace_lwlocks. Patch by me, revie