Request a Demo
Home   >   mailing lists

Re: [PATCH] Allow SJE to recognize GiST-backed temporal primary keys - Mailing list pgsql-hackers

From David Rowley
Subject Re: [PATCH] Allow SJE to recognize GiST-backed temporal primary keys
Date
Msg-id CAApHDvqKOSZ+ZacOc8B4WE0i70w97Ji_74KRmTf5Uf5dQX1ncA@mail.gmail.com
Whole thread
In response to [PATCH] Allow SJE to recognize GiST-backed temporal primary keys  (SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>)
List pgsql-hackers
Tree view 
On Wed, 22 Apr 2026 at 07:18, SATYANARAYANA NARLAPURAM
<satyanarlapuram@gmail.com> wrote:
> relation_has_unique_index_for() checks whether join clause equality
> operators belong to the index's opfamily via mergeopfamilies.  Since
> mergeopfamilies only lists btree opfamilies, this check always fails
> for GiST-backed unique indexes such as those created by PRIMARY KEY
> with WITHOUT OVERLAPS, preventing self-join elimination.

Please add to the 20-1 CF [1].

David

[1] https://commitfest.postgresql.org/59/

pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server
Next
From: jian he
Date:
Subject: Re: on_error table, saving error info to a table