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
