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@centos-cpula bin]$ ./pg_dump -FP -p 5000 postgres > /tmp/a.a
\\check the syntax
[centos@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
