Correct docs about partitions and EXCLUDE constraints
Paul A Jungwirth <pj@illuminatedcomputing.com>
From: Paul Jungwirth <pj@illuminatedcomputing.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-06-18T18:25:20Z
Lists: pgsql-hackers
Attachments
- v1-0001-Correct-docs-about-partitions-and-EXCLUDE-constra.patch (text/x-patch) patch v1-0001
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@illuminatedcomputing.com
Commits
-
Correct docs about partitions and EXCLUDE constraints.
- 0f5ac7f321fb 17.6 landed
- 6c29088fc6e2 18.0 landed