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

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

  1. Correct docs about partitions and EXCLUDE constraints.