Re: [PATCH] Allow SJE to recognize GiST-backed temporal primary keys

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>
Subject: Re: [PATCH] Allow SJE to recognize GiST-backed temporal primary keys
Date: 2026-04-22 01:54:33
Message-ID: CAApHDvqKOSZ+ZacOc8B4WE0i70w97Ji_74KRmTf5Uf5dQX1ncA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 22 Apr 2026 at 07:18, SATYANARAYANA NARLAPURAM
<satyanarlapuram(at)gmail(dot)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/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2026-04-22 02:11:46 Re: on_error table, saving error info to a table
Previous Message Chao Li 2026-04-22 01:51:36 Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server