Skip to main content

Module unique

Module unique 

Source
Expand description

Unique-index access-method and partition-key declaration rules.

Structs§

PartitionedUniqueKey
A unique key as PostgreSQL’s DefineIndex matches it against a partition key.

Functions§

validate_partitioned_key_constraint
Validate a key constraint of a partitioned table by its key columns; its INCLUDE columns 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’s DefineIndex does, the partition key is scanned in order: an expression cannot be matched at all, a column must be one of the key columns, and the WITHOUT OVERLAPS column 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