Expand description
The foreign keys a partition holds for the foreign keys of its partitioned parent: an equivalent foreign key of its own that it attaches, or a copy, as PostgreSQL’s tryAttachPartitionForeignKey and addFkConstraint decide.
Enums§
- Declared
Foreign Key - A foreign key of a declaration, by the catalog row it publishes.
Functions§
- attachable_
foreign_ key - The foreign key of
partitionthatparent_keyattaches amongcandidates, the partition’s foreign keys that copy none of its parent’s, in name order: the first that references the same key through the same columns with the same deferrability, actions and match type. A candidate that differs fromparent_keyin enforceability alone is an error, asPostgreSQLrefuses to attach it or to add a second constraint beside it. - declared_
foreign_ key_ families - The object identities of the foreign keys a declaration holds, which its partitions’ copies share.
- partition_
foreign_ key_ copy - A partition’s copy of
parent_key, which keeps the parent’s name unless one of the partition’s constraints inusedholds it, when it takes the parent’s name with the first numeric suffix that no constraint of the partition’s schema, inschema, holds, asPostgreSQL’saddFkConstraintnames it. - rejoin_
foreign_ key_ families - Move the foreign keys of a declaration whose families joined others into those families: the copies of a foreign key that a partition attached to its parent’s follow it. Reports whether any moved.