Collected from the PG bugs email list.
|OS||CentOS Linux release 7.3.1611 (Core)|
|Reported by||Stepan 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) 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 : 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?
|2019-09-25 07:11:28+00||PG Bug reporting form||BUG #16021: Can create Pk on partitioned table with foreign table as partition|
|2019-09-25 07:48:42+00||Etsuro Fujita||Re: BUG #16021: Can create Pk on partitioned table with foreign table as partition|