Horton

Thread

Commits

  1. Correct docs about partitions and EXCLUDE constraints.

  1. Correct docs about partitions and EXCLUDE constraints

    Paul A Jungwirth <pj@illuminatedcomputing.com> — 2025-06-18T18:25:20Z

    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

  2. Re: Correct docs about partitions and EXCLUDE constraints

    Jeff Davis <pgsql@j-davis.com> — 2025-06-19T15:43:36Z

    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

  3. Re: Correct docs about partitions and EXCLUDE constraints

    Paul A Jungwirth <pj@illuminatedcomputing.com> — 2025-06-19T19:09:47Z

    On 6/19/25 08:43, Jeff Davis wrote:
> 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.

I agree this new location makes more sense. The wording looks good.

Thanks!

-- 
Paul              ~{:-)
pj@illuminatedcomputing.com