On 2021-01-18 00:35, Robert Haas wrote:
I don't have any complaint about labelling some of the unique indexes as primary keys, but I think installing foreign keys that don't really enforce anything may lead to confusion.
FWIW, "not enforced" constraints (such as foreign keys) is a feature that is in the SQL standard and in other SQL implementations.
-- Peter Eisentraut 2ndQuadrant, an EDB company https://www.2ndquadrant.com/
