Re: Fix WITHOUT OVERLAPS PKs used for functional grouping - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Fix WITHOUT OVERLAPS PKs used for functional grouping
Date
Msg-id udmu3f7q64vwt6tmimdqmei4h3yie2jgtcm4sqlz2muvu6s4qg@sttmjgnnxblk
Whole thread
In response to Fix WITHOUT OVERLAPS PKs used for functional grouping  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-hackers
Hi,

On 2026-10-08 21:30:24 -0700, Paul A Jungwirth wrote:
> Andres reported that a WITHOUT OVERLAPS primary key is wrongly
> considered valid for functional grouping.[0] The problem is that the
> GiST equals operator may not behave the same as the default btree
> operator, which is what GROUP BY uses. This patch disables functional
> grouping for WITHOUT OVERLAPS PKs.

Without commenting about anything else, can you please not start separate
threads for all these? Hackers is too busy to be able to keep up with
everything, no need to make it even worse.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Zsolt Parragi
Date:
Subject: Re: Unlogged materialized views
Next
From: Andres Freund
Date:
Subject: Re: Fix WITHOUT OVERLAPS PKs used for functional grouping