Re: Support EXCEPT for TABLES IN SCHEMA publications - Mailing list pgsql-hackers

From Peter Smith
Subject Re: Support EXCEPT for TABLES IN SCHEMA publications
Date
Msg-id CAHut+Pu5VNakf5JAhKM7T-P_q37eN1Qgv5nvZUe+8RAAT41y4g@mail.gmail.com
Whole thread
In response to Re: Support EXCEPT for TABLES IN SCHEMA publications  (Nisha Moond <nisha.moond412@gmail.com>)
List pgsql-hackers
Hi Nisha.

A couple of ad-hoc review comments for v4-0001...

======
src/bin/pg_dump/pg_dump.c

dumpPublicationNamespace:

1.
+ if (!first_except)
+ appendPQExpBufferStr(query, ")");

The logic seems ok, but the above seems a bit strange, checking
'first_except'. Maybe renaming to 'has_except' (and some small
refactoring) would read better?

~~~

2.
IIUC, the 'ALTER PUBLICATION' EXCEPT clause syntax change is not
introduced until your patch 0003. So, how does this dump code even
work when it relies on that ALTER PUBLICATION?

Furthermore, the patch 0003 commit message says 'ALTER PUBLICATION pub
SET TABLES', but this dump code is using 'ALTER PUBLICATION pub ADD
TABLES' (note ADD v SET). Something seems suspicious...

======
Kind Regards,
Peter Smith.
Fujitsu Australia



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication
Next
From: shveta malik
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication