[HACKERS] Logical replication and inheritance
От | Amit Langote |
---|---|
Тема | [HACKERS] Logical replication and inheritance |
Дата | |
Msg-id | 92ea7dd8-70b9-16c6-9327-e67e56209f33@lab.ntt.co.jp обсуждение исходный текст |
Ответы |
Re: [HACKERS] Logical replication and inheritance
|
Список | pgsql-hackers |
I see that if the table is a inheritance parent, and ONLY is not specified, the child tables are also added to the publication. create table parent (a int); create table child () inherits (parent); create publication parent_pub for table parent; \d parent Table "public.parent"Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+---------a | integer | | | Publications: "parent_pub" Number of child tables: 1 (Use \d+ to list them.) \d child Table "public.child"Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+---------a | integer | | | Publications: "parent_pub" Inherits: parent If the child table is later removed from the inheritance hierarchy, it continues to be a part of the publication. alter table child no inherit parent; ALTER TABLE \d child Table "public.child"Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+---------a | integer | | | Publications: "parent_pub" Perhaps that's intentional? Thanks, Amit
В списке pgsql-hackers по дате отправления: