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-09-26 14:26:32
Message-ID: CAOP7+xgnM+tPHWDFEonj7nrkL+-CyY-04Yz9QxDN-x05z+aeRA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 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!

Attachment Content-Type Size
v1-0001-Fix-pg_trgm-GiST-union-dropping-SIGNKEY-from-all-.patch application/octet-stream 948 bytes

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2026-09-26 14:39:35 Re: BUG #19722: Window PARTITION BY numeric treats equal values with different scales as separate partitions
Previous Message Ayush Tiwari 2026-09-26 14:25:10 Re: BUG #19723: CREATE INDEX racing with ALTER INDEX ATTACH PARTITION triggers unexpected internal error