[COMMITTERS] pgsql: Remove or reduce verbosity of some debug messages.

2016-11-17 Thread Robert Haas
Remove or reduce verbosity of some debug messages. The debug messages that merely print StartTransactionCommand, CommitTransactionCommand, ProcessUtilty, or ProcessQuery with no additional details seem to be useless. Get rid of them. The transaction status messages produced by ShowTransactionSta

[COMMITTERS] pgsql: Fix pg_dump's handling of circular dependencies in views.

2016-11-17 Thread Tom Lane
Fix pg_dump's handling of circular dependencies in views. pg_dump's traditional solution for breaking a circular dependency involving a view was to create the view with CREATE TABLE and then later issue CREATE RULE "_RETURN" ... to convert the table to a view, relying on the backend's very very an

[COMMITTERS] pgsql: Improve pg_dump/pg_restore --create --if-exists logic.

2016-11-17 Thread Tom Lane
Improve pg_dump/pg_restore --create --if-exists logic. Teach it not to complain if the dropStmt attached to an archive entry is actually spelled CREATE OR REPLACE VIEW, since that will happen due to an upcoming bug fix. Also, if it doesn't recognize a dropStmt, have it print a WARNING and then em

[COMMITTERS] pgsql: Improve pg_dump/pg_restore --create --if-exists logic.

2016-11-17 Thread Tom Lane
Improve pg_dump/pg_restore --create --if-exists logic. Teach it not to complain if the dropStmt attached to an archive entry is actually spelled CREATE OR REPLACE VIEW, since that will happen due to an upcoming bug fix. Also, if it doesn't recognize a dropStmt, have it print a WARNING and then em

[COMMITTERS] pgsql: Improve pg_dump/pg_restore --create --if-exists logic.

2016-11-17 Thread Tom Lane
Improve pg_dump/pg_restore --create --if-exists logic. Teach it not to complain if the dropStmt attached to an archive entry is actually spelled CREATE OR REPLACE VIEW, since that will happen due to an upcoming bug fix. Also, if it doesn't recognize a dropStmt, have it print a WARNING and then em

[COMMITTERS] pgsql: Improve pg_dump/pg_restore --create --if-exists logic.

2016-11-17 Thread Tom Lane
Improve pg_dump/pg_restore --create --if-exists logic. Teach it not to complain if the dropStmt attached to an archive entry is actually spelled CREATE OR REPLACE VIEW, since that will happen due to an upcoming bug fix. Also, if it doesn't recognize a dropStmt, have it print a WARNING and then em

[COMMITTERS] pgsql: Re-pgindent src/bin/pg_dump/*

2016-11-17 Thread Tom Lane
Re-pgindent src/bin/pg_dump/* Cleanup for recent patches --- it's not much change, but I got annoyed while re-indenting the view-rule fix I'm working on. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/fcf70e0dbca1432959be5f3557acd546d639c9ba Modified Files

[COMMITTERS] pgsql: Avoid pin scan for replay of XLOG_BTREE_VACUUM in all cases

2016-11-17 Thread Alvaro Herrera
Avoid pin scan for replay of XLOG_BTREE_VACUUM in all cases Replay of XLOG_BTREE_VACUUM during Hot Standby was previously thought to require complex interlocking that matched the requirements on the master. This required an O(N) operation that became a significant problem with large indexes, causi

[COMMITTERS] pgsql: Avoid pin scan for replay of XLOG_BTREE_VACUUM in all cases

2016-11-17 Thread Alvaro Herrera
Avoid pin scan for replay of XLOG_BTREE_VACUUM in all cases Replay of XLOG_BTREE_VACUUM during Hot Standby was previously thought to require complex interlocking that matched the requirements on the master. This required an O(N) operation that became a significant problem with large indexes, causi

[COMMITTERS] pgsql: Avoid pin scan for replay of XLOG_BTREE_VACUUM in all cases

2016-11-17 Thread Alvaro Herrera
Avoid pin scan for replay of XLOG_BTREE_VACUUM in all cases Replay of XLOG_BTREE_VACUUM during Hot Standby was previously thought to require complex interlocking that matched the requirements on the master. This required an O(N) operation that became a significant problem with large indexes, causi

[COMMITTERS] pgsql: Avoid pin scan for replay of XLOG_BTREE_VACUUM in all cases

2016-11-17 Thread Alvaro Herrera
Avoid pin scan for replay of XLOG_BTREE_VACUUM in all cases Replay of XLOG_BTREE_VACUUM during Hot Standby was previously thought to require complex interlocking that matched the requirements on the master. This required an O(N) operation that became a significant problem with large indexes, causi