| From: | Arseny Sher <a(dot)sher(at)postgrespro(dot)ru> |
|---|---|
| To: | "pgsql-hackers\(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Indexes on partitioned tables and foreign partitions |
| Date: | 2018-05-09 11:50:04 |
| Message-ID: | 87sh71cakz.fsf@ars-thinkpad |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
| Attachment | Content-Type | Size |
|---|---|---|
| dont_create_part_index_on_ftable.patch | text/x-diff | 1011 bytes |
| unknown_filename | text/plain | 95 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Etsuro Fujita | 2018-05-09 11:50:55 | Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. |
| Previous Message | Oleksandr Shulgin | 2018-05-09 09:49:25 | Re: Setting libpq TCP keepalive parameters from environment |