Re: Skipping schema changes in publication

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Cc: Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(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-02-19 12:24:00
Message-ID: CAA4eK1L2D0mvSEKLNTvjD1JX_K1_WPkXXZ3wB2Q5UJ3iRyOxPw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Feb 19, 2026 at 4:08 PM Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
>
> 3. Question, what would be the behavior of
> pg_get_publication_tables(), if we have created PUBLICATION FOR ALL
> TABLES with EXCEPT, I assume it will give all table even in the EXCEPT
> list
>

No, it won't return the tables mentioned in the except list and I
think that is what we expect from this function.

> as we have another function to get effective tables i.e.
> pg_get_publication_effective_tables(),
>

This function is for a different purpose and I think its name can be
improved, how about pg_get_publication_partitions() or something on
those lines?

--
With Regards,
Amit Kapila.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2026-02-19 13:06:34 RE: Selectively invalidate caches in pgoutput module
Previous Message John Naylor 2026-02-19 12:19:30 Re: centralize CPU feature detection