[HACKERS] "create publication..all tables" ignore 'partition not supported'error
От | tushar |
---|---|
Тема | [HACKERS] "create publication..all tables" ignore 'partition not supported'error |
Дата | |
Msg-id | 6f3db55a-f273-24d7-c4be-04aa1b1da0d8@enterprisedb.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] "create publication..all tables" ignore 'partition notsupported' error
|
Список | pgsql-hackers |
Hi, I observed that - "create publication..all tables" ignore 'partition not supported' error \\create a partition table You are now connected to database "s" as user "centos". s=# CREATE TABLE measurement ( s(# city_id int not null, s(# logdate date not null, s(# peaktemp int, s(# unitsales int s(# ) PARTITION BY RANGE (logdate); CREATE TABLE s=# \\try to publish only this table s=# create publication p for table measurement; ERROR: "measurement" is a partitioned table DETAIL: Adding partitioned tables to publications is not supported. HINT: You can add the table partitions individually. \\try to create publication for all tables s=# create publication p for all tables ; CREATE PUBLICATION s=# \d+ measurement Table "public.measurement" Column | Type | Collation | Nullable| Default | Storage | Stats target | Description -----------+---------+-----------+----------+---------+---------+--------------+------------- city_id | integer | | not null | | plain | | logdate | date | | not null | | plain | | peaktemp | integer | | | | plain | | unitsales | integer | | | | plain | | Partition key: RANGE (logdate) Publications: "p" Publication 'p' has been set against partition table ,which is not supported. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления: