Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY

From: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Nate Clark <natec425(at)gmail(dot)com>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY
Date: 2026-11-03 10:35:55
Message-ID: CAJTYsWWfd1=DDAn2D2JjTz3HjKpi0mXDRguy-R1By942W2C+Hw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On Tue, 3 Nov 2026 at 15:03, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>
> On Mon, Oct 5, 2026 at 12:37 PM Ayush Tiwari
> <ayushtiwari(dot)slg01(at)gmail(dot)com> wrote:
> > Thanks for the report and patch. The fix looks right to me.
>
> This should be backpatched to all supported versions?

Yes, this needs to be backpatched till PG 14.

> The fix doesn't repair existing indexes. Right? If so, we should advise users
> to REINDEX all existing gist_trgm_ops indexes after upgrading to a minor
> release containing the fix?

Right, I still needed REINDEX after updating the library. I agree
we should mention that in the release notes.

Regards,
Ayush

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message Fujii Masao 2026-11-03 09:32:53 Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY