[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 по дате отправления: