Horton

Indexes on partitioned tables and foreign partitions

Arseny Sher <a.sher@postgrespro.ru>

View thread View on postgr.es
From: Arseny Sher <a.sher@postgrespro.ru>
To: "pgsql-hackers\@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2018-05-09T11:50:04Z
Lists: pgsql-hackers

Attachments

Hi,

8b08f7d4 added propagation of indexes on partitioned tables to
partitions, which is very cool. However, index creation also recurses
down to foreign tables. I doubt this is intentional, as such indexes are
forbidden as not making much sense; attempt to create index on
partitioned table with foreign partition leads to an error
now. Attached lines fix this.

Commits

  1. Don't allow partitioned index on foreign-table partitions