| From: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> | 
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | "create publication..all tables" ignore 'partition not supported' error | 
| Date: | 2017-05-22 09:09:04 | 
| Message-ID: | 6f3db55a-f273-24d7-c4be-04aa1b1da0d8@enterprisedb.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2017-05-22 09:16:38 | Re: PG10 Crash-safe and replicable Hash Indexes and UNIQUE | 
| Previous Message | amul sul | 2017-05-22 08:53:31 | Re: [POC] hash partitioning |