why can't a table be part of the same publication as its schema

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема why can't a table be part of the same publication as its schema
Дата
Msg-id 2729c9e2-9aac-8cda-f2f4-34f2bcc18f4e@enterprisedb.com
обсуждение исходный текст
Ответы Re: why can't a table be part of the same publication as its schema  (Amit Kapila <amit.kapila16@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Dmitry Koval
Дата:
Сообщение: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: proposal: possibility to read dumped table's name from file