[COMMITTERS] pgsql: Disallow CREATE/DROP SUBSCRIPTION in transaction block

2017-03-03 Thread Peter Eisentraut
Disallow CREATE/DROP SUBSCRIPTION in transaction block Disallow CREATE SUBSCRIPTION and DROP SUBSCRIPTION in a transaction block when the replication slot is to be created or dropped, since that cannot be rolled back. based on patch by Masahiko Sawada Branch -- master Details --- http:

[COMMITTERS] pgsql: Fix parsing of DROP SUBSCRIPTION ... DROP SLOT

2017-03-03 Thread Peter Eisentraut
Fix parsing of DROP SUBSCRIPTION ... DROP SLOT It didn't actually parse before. Reported-by: Masahiko Sawada Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/347302730dc3092143ccbc1c29b47ac3354f924b Modified Files -- src/backend/parser/gram.y

[COMMITTERS] pgsql: Fix two recently introduced grammar errors in mmgr/README.

2017-03-03 Thread Andres Freund
Fix two recently introduced grammar errors in mmgr/README. These were introduced by me in f4e2d50c. Reported-By: Tomas Vondra Discussion: https://postgr.es/m/11adca69-be28-44bc-a801-64e6d5385...@2ndquadrant.com Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/130937

[COMMITTERS] pgsql: Fix typo

2017-03-03 Thread Peter Eisentraut
Fix typo Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2357c12b4988b4d30c1e2e813e438424546eaa88 Modified Files -- src/backend/commands/tablecmds.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) -- Sent via pgsql-committers mailing list (pgs

[COMMITTERS] pgsql: doc: Put callouts in SQL comments

2017-03-03 Thread Peter Eisentraut
doc: Put callouts in SQL comments This makes copy-and-pasting the SQL code easier. From: Thomas Munro Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/47b55d4174fd5662cd2f8c40852a20eec5f07c8f Modified Files -- doc/src/sgml/plpgsql.sgml | 10 +- d

[COMMITTERS] pgsql: psql: Add tab completion for logical replication

2017-03-03 Thread Peter Eisentraut
psql: Add tab completion for logical replication Add tab completion for publications and subscriptions. Also, to be able to get a list of subscriptions, make pg_subscription world-readable but revoke access to subconninfo using column privileges. From: Michael Paquier Branch -- master Det

[COMMITTERS] pgsql: Add RENAME support for PUBLICATIONs and SUBSCRIPTIONs

2017-03-03 Thread Peter Eisentraut
Add RENAME support for PUBLICATIONs and SUBSCRIPTIONs From: Petr Jelinek Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/6da9759a03d6d985c3b95a3177bbda7bcffd0ae6 Modified Files -- src/backend/commands/alter.c | 15 +++ src/backe

[COMMITTERS] pgsql: Fix after trigger execution in logical replication

2017-03-03 Thread Peter Eisentraut
Fix after trigger execution in logical replication From: Petr Jelinek Tested-by: Thom Brown Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/713f7c47d9c38654adbc36c47fd9e439f0d1f715 Modified Files -- src/backend/replication/logical/worker.c | 15

[COMMITTERS] pgsql: Use asynchronous connect API in libpqwalreceiver

2017-03-03 Thread Peter Eisentraut
Use asynchronous connect API in libpqwalreceiver This makes the connection attempt from CREATE SUBSCRIPTION and from WalReceiver interruptable by the user in case the libpq connection is hanging. The previous coding required immediate shutdown (SIGQUIT) of PostgreSQL in that situation. From: Pet

[COMMITTERS] pgsql: Allow vacuums to report oldestxmin

2017-03-03 Thread Simon Riggs
Allow vacuums to report oldestxmin Allow VACUUM and Autovacuum to report the oldestxmin value they used while cleaning tables, helping to make better sense out of the other statistics we report in various cases. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9eb344f