| From: | Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | why can't a table be part of the same publication as its schema |
| Date: | 2022-09-08 11:36:07 |
| Message-ID: | 2729c9e2-9aac-8cda-f2f4-34f2bcc18f4e@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Gustafsson | 2022-09-08 11:38:42 | Re: proposal: possibility to read dumped table's name from file |
| Previous Message | Dmitry Koval | 2022-09-08 11:35:24 | Re: Add SPLIT PARTITION/MERGE PARTITIONS commands |