Re: [HACKERS] Index created in BEFORE trigger not updated duringINSERT - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [HACKERS] Index created in BEFORE trigger not updated duringINSERT
Date
Msg-id 20170603224715.5w4vnmpu2zypucfv@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] Index created in BEFORE trigger not updated during INSERT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2017-06-03 18:23:33 -0400, Tom Lane wrote:
> Attached is a proposed patch that closes off this problem.  I've tested
> it to the extent that it blocks Albe's example and passes check-world.

Cool.

> I'm unsure whether to back-patch or not; the main argument for not doing
> so is that if any extensions are calling DefineIndex() directly, this
> would be an API break for them.  Given what a weird case this is, I'm not
> sure it's worth that.

I slightly lean against backpatching, it has taken long to be reported,
and it's pretty easy to work around...

- Andres



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Index created in BEFORE trigger not updated during INSERT
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Extra Vietnamese unaccent rules