BUG #16021: Can create Pk on partitioned table with foreign table as partition

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
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)

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?


Browse pgsql-bugs by date

  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