Horton

Re: Assertion on create index concurrently

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Paquier <michael@paquier.xyz>
Cc: Andrey Lepikhov <a.lepikhov@postgrespro.ru>, pgsql-bugs@lists.postgresql.org
Date: 2021-06-27T15:37:16Z
Lists: pgsql-bugs 
Michael Paquier <michael@paquier.xyz> writes:
> On Sat, Jun 26, 2021 at 09:48:45PM +0300, Andrey Lepikhov wrote:
>> This problem affects PG 9.6 - 13. The master branch was fixed 9 months ago
>> by commit 83158f7, that made this operation transactional, but still.

> This looks like a good argument for back-patching 83158f7 all the way
> down, as 813fb03 exists since 9.4.  Any thoughts from others?

+1 ... 83158f7 has survived long enough to have reasonable confidence
in it.

			regards, tom lane

Commits

  1. Add test for CREATE INDEX CONCURRENTLY with not-so-immutable predicate

  2. Make index_set_state_flags() transactional