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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
