[BUG] Partition creation fails after dropping a column and adding a partial index

From: Wyatt Alt <wyatt(dot)alt(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [BUG] Partition creation fails after dropping a column and adding a partial index
Date: 2019-10-29 04:00:24
Message-ID: CAGem3qCcRmhbs4jYMkenYNfP2kEusDXvTfw-q+eOhM0zTceG-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,
I think this demonstrates a bug, tested in 11.5:
https://gist.github.com/wkalt/a298fe82c564668c803b3537561e67a0

The same script succeeds if the index on line 11 is either dropped, made to
be non-partial on b, or shifted to a different column (the others are used
in the partitioning; maybe significant).

This seems somewhat related to
https://www.postgresql.org/message-id/flat/CAFjFpRc0hqO5hc-%3DFNePygo9j8WTtOvvmysesnN8bfkp3vxHPQ%40mail.gmail.com#00ca695e6c71834622a6e42323f5558a
.

Regards,
Wyatt

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Wyatt Alt 2019-10-29 04:16:10 Re: [BUG] Partition creation fails after dropping a column and adding a partial index
Previous Message Justin Pryzby 2019-10-29 03:56:33 Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)