Don't allow partitioned index on foreign-table partitions
Alvaro Herrera <alvherre@alvh.no-ip.org>
Don't allow partitioned index on foreign-table partitions Creating indexes on foreign tables is already forbidden, but local partitioned indexes (commit 8b08f7d4820f) forgot to check for them. Add a preliminary check to prevent wasting time. Another school of thought says to allow the index to be created if it's not a unique index; but it's possible to do better in the future (enable indexing of foreign tables, somehow), so we avoid painting ourselves in a corner by rejecting all cases, to avoid future grief (a.k.a. backward incompatible changes). Reported-by: Arseny Sher Author: Amit Langote, Álvaro Herrera Discussion: https://postgr.es/m/87sh71cakz.fsf@ars-thinkpad
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/tcop/utility.c | modified | +26 −12 |
| src/test/regress/expected/foreign_data.out | modified | +7 −0 |
| src/test/regress/sql/foreign_data.sql | modified | +6 −0 |
Discussion
- Indexes on partitioned tables and foreign partitions 25 messages · 2018-05-09 → 2018-05-15