From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Guo <guofenglinux@gmail.com>
cc: Peter Eisentraut <peter@eisentraut.org>, exclusion@gmail.com,
        pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19000: gist index returns inconsistent result with
 gist_inet_ops
In-reply-to: 
 <CAMbWs48sCRUbz0CmkPSFEH8G1b9y-erq6rqYpA0sPhb_ZmwOpQ@mail.gmail.com>
References: <19000-2525470d200672ab@postgresql.org>
 <CAMbWs49vGc45oQ98bhx4dFpXOsimUX9TTnXOXG=i6+X6sAqBRw@mail.gmail.com>
 <d570c46d-1e20-4766-93de-c6fcbc18f282@eisentraut.org>
 <2107725.1753985855@sss.pgh.pa.us>
 <CAMbWs48sCRUbz0CmkPSFEH8G1b9y-erq6rqYpA0sPhb_ZmwOpQ@mail.gmail.com>
Comments: In-reply-to Richard Guo <guofenglinux@gmail.com>
	message dated "Fri, 01 Aug 2025 11:38:31 +0900"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2189026.1754019208.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Thu, 31 Jul 2025 23:33:28 -0400
Message-ID: <2189027.1754019208@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2189027.1754019208%40sss.pgh.pa.us>
Precedence: bulk

Richard Guo <guofenglinux@gmail.com> writes:
> On Fri, Aug 1, 2025 at 3:17 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> We've known about this for, um, decades: btree_gist's support for
>> inet/cidr is fundamentally broken [1][2].  It's still there
>> only because nobody's been able to think of a way of removing it
>> without causing pain for anyone who has indexes like that.
>> But maybe we should just accept that it's going to cause pain
>> and remove it.

> I think correctness should take priority over avoiding pain.

Yeah.  I spent a little time investigating this today, and hope
to have a patch to propose tomorrow.

			regards, tom lane