| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Index created in BEFORE trigger not updated during INSERT |
| Date: | 2017-06-03 22:47:15 |
| Message-ID: | 20170603224715.5w4vnmpu2zypucfv@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2017-06-03 23:12:12 | Re: Extra Vietnamese unaccent rules |
| Previous Message | Michael Paquier | 2017-06-03 22:44:54 | Re: Index created in BEFORE trigger not updated during INSERT |