Try
Home   >   mailing lists

Re: BUG #19000: gist index returns inconsistent result with gist_inet_ops - Mailing list pgsql-bugs

From Richard Guo
Subject Re: BUG #19000: gist index returns inconsistent result with gist_inet_ops
Date
Msg-id CAMbWs49ucxae5_FfDDAPXuJYY1W2mQvz=BomPe62Mas_QR3FXQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #19000: gist index returns inconsistent result with gist_inet_ops  (Stepan Neretin <slpmcf@gmail.com>)
List pgsql-bugs
Tree view 
On Mon, Jul 28, 2025 at 3:39 PM Stepan Neretin <slpmcf@gmail.com> wrote:
> I tried to reproduce this issue on PostgreSQL 18beta2 (commit 3151c264) on Ubuntu 24.04, but I could not observe the
incorrectbehavior described. 

> So the query still returns the expected row after the GiST index is created.
> If there are any additional settings or steps required to reproduce, please let me know.

You'll need to ensure that the plan uses an index scan.  Setting
enable_seqscan to off should be sufficient to do so.

Thanks
Richard

pgsql-bugs by date:

Previous
From: Stepan Neretin
Date:
Subject: Re: BUG #19000: gist index returns inconsistent result with gist_inet_ops
Next
From: Amit Kapila
Date:
Subject: Re: Unexpected Standby Shutdown on sync_replication_slots change