Re: [patch] Bug in pg_dump/pg_restore using --no-publication - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [patch] Bug in pg_dump/pg_restore using --no-publication
Date
Msg-id 20180925020830.GE1354@paquier.xyz
Whole thread Raw
In response to [patch] Bug in pg_dump/pg_restore using --no-publication  (Gilles Darold <gilles.darold@dalibo.com>)
List pgsql-hackers
On Fri, Sep 21, 2018 at 05:44:02PM +0200, Gilles Darold wrote:
> Attached is a patch that fixes a bug in pg_dump since 10.0 and
> reproducible in master. When using option --no-publication : ALTER
> PUBLICATION orders are still present in the dump.

Thanks for the report, the patch, and the test case, Gilles!

> pg_restore --no-publication test.dump -l test.dump| grep PUBLICATION
> 2230; 6106 16389 PUBLICATION TABLE public p1 t1
> 2231; 6106 16392 PUBLICATION TABLE public p_insert_only t1

This command does not actually work ;)

> Should I add it to current commitfest ?

No need to.  I have committed your patch down to v10 after making sure
that we are not missing any other spots, and testing each branch
manually.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: "Tsunakawa, Takayuki"
Date:
Subject: RE: Changing the setting of wal_sender_timeout per standby
Next
From: Thomas Munro
Date:
Subject: DNS SRV support for LDAP authentication