why can't a table be part of the same publication as its schema - Mailing list pgsql-hackers

From Peter Eisentraut
Subject why can't a table be part of the same publication as its schema
Date
Msg-id 2729c9e2-9aac-8cda-f2f4-34f2bcc18f4e@enterprisedb.com
Whole thread Raw
Responses Re: why can't a table be part of the same publication as its schema
List pgsql-hackers
Apparently, you can't add a table to a publication if its schema is 
already part of the publication (and vice versa), e.g.,

=# alter publication p1 add table s1.t1;
ERROR:  22023: cannot add relation "s1.t1" to publication
DETAIL:  Table's schema "s1" is already part of the publication or part 
of the specified schema list.

Is there a reason for this?  It looks a bit like a misfeature to me.  It 
constrains how you can move your tables around between schemas, based on 
how somewhere else a publication has been constructed.

It seems to me that it shouldn't be difficult to handle the case that a 
table is part of the publication via two different routes.  (We must 
already handle that since a subscription can use more than one publication.)



pgsql-hackers by date:

Previous
From: Dmitry Koval
Date:
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Next
From: Daniel Gustafsson
Date:
Subject: Re: proposal: possibility to read dumped table's name from file