| From: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
| Cc: | shveta malik <shveta(dot)malik(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, YeXiu <1518981153(at)qq(dot)com>, Ian Lawrence Barwick <barwick(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Skipping schema changes in publication |
| Date: | 2026-03-10 20:54:31 |
| Message-ID: | CAD21AoBdE5GXw6PayASYUEkrWi6UQ6fNeOsuxf_+wVMkLZzOMA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Mar 4, 2026 at 3:01 AM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Wed, Mar 4, 2026 at 2:49 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
> >
> > On Wed, Mar 4, 2026 at 1:54 PM vignesh C <vignesh21(at)gmail(dot)com> wrote:
> > >
> > > Here is an updated version with a couple of typos fixed and separated
> > > the describe table query based on versions which make it more easier
> > > to read.
> > >
> >
> > v56 LGTM.
> >
>
> Pushed.
Sorry for joining the discussion late.
I've tried with the new EXCEPT clause and I have some questions about
the newly introduced syntax. With this feature, we can now write:
CREATE PUBLICATION pub FOR ALL TABLES EXCEPT TABLE (a, b, c);
The exclusion table list is written in the form of TABLE (a, b, c) but
it's quite different from the inclusion table list we can specify
(e.g., TABLE a, TABLE b, TABLE c). I'm concerned that it could confuse
users. Have these points already been discussed? Also, isn't the TABLE
after EXCEPT redundant?
Regards,
--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2026-03-10 20:55:44 | Re: Use allocation macros in the logical replication code |
| Previous Message | Andres Freund | 2026-03-10 20:41:09 | Re: Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations |