Re: Correct docs about partitions and EXCLUDE constraints
Jeff Davis <pgsql@j-davis.com>
From: Jeff Davis <pgsql@j-davis.com>
To: Paul Jungwirth <pj@illuminatedcomputing.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-06-19T15:43:36Z
Lists: pgsql-hackers
Attachments
- 0001-Correct-docs-about-partitions-and-EXCLUDE-constraint.patch (text/x-patch) patch 0001
On Wed, 2025-06-18 at 11:25 -0700, Paul Jungwirth wrote: > 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. Leaving it in the entry for PARTITION BY seems out of place; shouldn't it be moved to the entry for EXCLUDE? I also merged your wording with some similar wording from the entry about UNIQUE. Attached. Regards, Jeff Davis
Commits
-
Correct docs about partitions and EXCLUDE constraints.
- 0f5ac7f321fb 17.6 landed
- 6c29088fc6e2 18.0 landed