Create publication syntax is not coming properly in pg_dump / pg_dumpall

From: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Create publication syntax is not coming properly in pg_dump / pg_dumpall
Date: 2017-05-15 08:04:59
Message-ID: 3427593a-61aa-b17e-64ef-383b7742d6d9@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I observed that in pg_dump/pg_dumpall - 'create publication' syntax is
not coming properly if only specified value is mentioned in publish.

Testcase to reproduce -

\\create a publication

postgres=# CREATE PUBLICATION abc for all tables with (publish='insert');
CREATE PUBLICATION

\\take the plain dump

[centos(at)centos-cpula bin]$ ./pg_dump -FP -p 5000 postgres > /tmp/a.a

\\check the syntax

[centos(at)centos-cpula bin]$ cat /tmp/a.a |grep 'create publication abc' -i
CREATE PUBLICATION abc FOR ALL TABLES WITH (publish = 'insert, , ');

\\try to execute the same syntax against psql terminal

postgres=# CREATE PUBLICATION abc FOR ALL TABLES WITH (publish =
'insert, , ');
ERROR: invalid publish list

Same is valid for pg_dumpall as well..

--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2017-05-15 09:06:33 Re: Small improvement to compactify_tuples
Previous Message Roel Janssen 2017-05-15 06:48:47 Re: postgres 9.6.2 update breakage