"create publication..all tables" ignore 'partition not supported' error

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-hackers by date

  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