Home > mailing lists

[BUG] Partition creation fails after dropping a column and adding apartial index - Mailing list pgsql-hackers

From	Wyatt Alt
Subject	[BUG] Partition creation fails after dropping a column and adding apartial index
Date	October 29, 2019 04:00:24
Msg-id	CAGem3qCcRmhbs4jYMkenYNfP2kEusDXvTfw-q+eOhM0zTceG-g@mail.gmail.com Whole thread Raw
Responses	Re: [BUG] Partition creation fails after dropping a column and addinga partial index Re: [BUG] Partition creation fails after dropping a column andadding a partial index
List	pgsql-hackers

Tree view

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

pgsql-hackers by date:

From: Justin Pryzby
Date: 29 October 2019, 03:56:33
Subject: Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)

From: Wyatt Alt
Date: 29 October 2019, 04:16:10
Subject: Re: [BUG] Partition creation fails after dropping a column and addinga partial index

[BUG] Partition creation fails after dropping a column and adding apartial index - Mailing list pgsql-hackers

Previous

Next