Expand description
Unique-index access-method and partition-key declaration rules.
Structs§
- Partitioned
Unique Key - A unique key as
PostgreSQL’sDefineIndexmatches it against a partition key.
Functions§
- validate_
partitioned_ key_ constraint - Validate a key constraint of a partitioned table by its key columns; its
INCLUDEcolumns take no part. - validate_
partitioned_ unique_ key - Every partition key column must be compared by equality in a unique key of a partitioned table, so that each partition’s index enforces the key alone. As
PostgreSQL’sDefineIndexdoes, the partition key is scanned in order: an expression cannot be matched at all, a column must be one of the key columns, and theWITHOUT OVERLAPScolumn is compared by&&rather than equality. - validate_
unique_ index_ method - validate_
unique_ index_ partition_ key - A unique index of a partitioned table holds every partition key column among its key columns.
- validate_
unique_ partition_ columns