| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Subject: | Re: Fix WITHOUT OVERLAPS PKs used for functional grouping |
| Date: | 2026-10-09 12:10:55 |
| Message-ID: | udmu3f7q64vwt6tmimdqmei4h3yie2jgtcm4sqlz2muvu6s4qg@sttmjgnnxblk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2026-10-09 12:22:30 | Re: Fix WITHOUT OVERLAPS PKs used for functional grouping |
| Previous Message | Zsolt Parragi | 2026-10-09 11:40:03 | Re: Unlogged materialized views |