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

Wyatt Alt <wyatt.alt@gmail.com>

From: Wyatt Alt <wyatt.alt@gmail.com>

To: pgsql-hackers@postgresql.org

Date: 2019-10-29T04:00:24Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix failure when creating cloned indexes for a partition
- f10815c5bf1b 11.6 landed
- 7963c4c4b782 12.1 landed
- dc816e581591 13.0 landed

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