Correct docs about partitions and EXCLUDE constraints

From: Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Correct docs about partitions and EXCLUDE constraints
Date: 2025-06-18 18:25:20
Message-ID: c955d292-b92d-42d1-a2a0-1ec6715a2546@illuminatedcomputing.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Hackers,

In pg17 we added support for cross-partition EXCLUDE constraints, as long as they included all
partition key columns and compared them with equality (see 8c852ba9a4). I updated the docs for
exclusion constraints, but I missed that the docs for CREATE TABLE still said that they were not
supported. This commit fixes that. I don't see a similar message in the ALTER TABLE docs.

I take it we should apply this patch to both v18 and v17?

Yours,

--
Paul ~{:-)
pj(at)illuminatedcomputing(dot)com

Attachment Content-Type Size
v1-0001-Correct-docs-about-partitions-and-EXCLUDE-constra.patch text/x-patch 1.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2025-06-18 18:36:04 Re: Document NULL
Previous Message Devrim Gündüz 2025-06-18 18:25:15 Re: minimum Meson version