From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | stepya(at)ukr(dot)net |
Subject: | BUG #16021: Can create Pk on partitioned table with foreign table as partition |
Date: | 2019-09-25 07:11:28 |
Message-ID: | 16021-173fccc4c9c27f8d@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 16021
Logged by: Stepan Yankevych
Email address: stepya(at)ukr(dot)net
PostgreSQL version: 11.5
Operating system: CentOS Linux release 7.3.1611 (Core)
Description:
As far as I can see the issue has been fixed in 11.5 with following
resolution:
Ignore partitions that are foreign tables when creating indexes on
partitioned tables (Álvaro Herrera)
Previously an error was thrown on encountering a foreign-table partition,
but that's unhelpful and doesn't protect against any actual problem.
But I still can't create Pk on partitioned table
See details:
SELECT version();
PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623
(Red Hat 4.8.5-36), 64-bit
ALTER TABLE fix_capture.fix_message_json ADD CONSTRAINT fix_message_json_pk
PRIMARY KEY (fix_message_id,date_id);
SQL Error [42809]: ERROR: cannot create unique index on partitioned table
"fix_message_json"
Detail: Table "fix_message_json" contains partitions that are foreign
tables.
Have I missed something?
From | Date | Subject | |
---|---|---|---|
Next Message | Etsuro Fujita | 2019-09-25 07:43:46 | Re: BUG #15724: Can't create foreign table as partition |
Previous Message | PG Bug reporting form | 2019-09-25 06:51:55 | BUG #16020: ICU Collations querys |