Re: [PATCH] Skip unpublishable child tables when adding parent to publication - Mailing list pgsql-hackers

From Euler Taveira
Subject Re: [PATCH] Skip unpublishable child tables when adding parent to publication
Date
Msg-id ca016f88-5d66-42b0-aae8-84d540352fff@app.fastmail.com
Whole thread Raw
In response to Re: [PATCH] Skip unpublishable child tables when adding parent to publication  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
On Tue, Dec 16, 2025, at 6:34 AM, Amit Kapila wrote:
>
> Prohibiting all commands sounds too restrictive in all cases (FOR ALL
> TABLES, FOR TABLE, etc.). It would be better if we can disallow
> creating a publication when the user explicitly adds such a relation
> in a FOR TABLE publication, otherwise raise a WARNING and don't make
> it part of publication. The behavior should be the same for both
> partition and inherited tables.
>

WFM. The attached patch checks the partitions too. The behavior is similar to
inherited tables. However, I didn't understand the "otherwise" part. Are you
suggesting to add WARNING in the FOR ALL TABLES and FOR TABLES IN SCHEMA if
there is any unsupported relations?


-- 
Euler Taveira
EDB   https://www.enterprisedb.com/
Attachment

pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: Re: Custom oauth validator options
Next
From: Peter Smith
Date:
Subject: Re: [Proposal] Adding Log File Capability to pg_createsubscriber