PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16021
PG Version11.5
OSCentOS Linux release 7.3.1611 (Core)
Opened2019-09-25 07:11:28+00
Reported byStepan Yankevych

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16021
Logged by:          Stepan Yankevych
Email address:      (redacted)
PostgreSQL version: 11.5
Operating system:   CentOS Linux release 7.3.1611 (Core)

As far as I can see  the issue has been fixed in 11.5 with following
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
  Detail: Table "fix_message_json" contains partitions that are foreign

Have I missed something?


2019-09-25 07:11:28+00PG Bug reporting formBUG #16021: Can create Pk on partitioned table with foreign table as partition
2019-09-25 07:48:42+00Etsuro FujitaRe: BUG #16021: Can create Pk on partitioned table with foreign table as partition