Horton

Correct docs about partitions and EXCLUDE constraints.

Jeff Davis <jdavis@postgresql.org>

View on postgr.es
Commit: 6c29088fc6e269b7d64797bb62533b82afe03d93
Author: Jeff Davis <jdavis@postgresql.org>
Date: 2025-06-19T19:43:27Z
Releases: 18.0 
Correct docs about partitions and EXCLUDE constraints.

In version 17 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.

Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Co-authored-by: Jeff Davis <pgsql@j-davis.com>
Discussion: https://postgr.es/m/c955d292-b92d-42d1-a2a0-1ec6715a2546@illuminatedcomputing.com
Backpatch-through: 17

Files

PathChange+/−
doc/src/sgml/ref/create_table.sgml modified +12 −5

Documentation touched

Discussion