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

From: Nate Clark <natec425(at)gmail(dot)com>
To: Kirill Reshke <reshkekirill(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY
Date: 2026-10-02 18:20:03
Message-ID: CAOP7+xhmk8aPKYCgrsBJN3eboQkt=1ReYUk9x3UwDi9dk2O36A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I went ahead and created a commitfest entry for this:
https://commitfest.postgresql.org/patch/7385/

Please let me know if I've done anything incorrectly!

On Sat, Sep 26, 2026 at 9:26 AM Nate Clark <natec425(at)gmail(dot)com> wrote:
>
> > Your analysis also looks correct for me, would you share a patch with
> > result->flag = ALLISTRUE; -> result->flag |= ALLISTRUE; ?
>
> Of course. I've attached a patch with that one line change.
>
> Please let me know if there is anything else I should do, and thanks
> for your help!

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message Manu 2026-10-02 18:01:07 Re: BUG #19701: GIN trigram index loses rows at similarity_threshold 0