Postgres Pro
Downloads
Home   >   mailing lists

Re: Add primary keys to system catalogs - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Add primary keys to system catalogs
Date
Msg-id de49a11e-b448-1af8-c3ac-e92c0b4e2a7d@2ndquadrant.com
Whole thread Raw
In response to Re: Add primary keys to system catalogs  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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/

pgsql-hackers by date:

Previous
From: Greg Nancarrow
Date:
Subject: Re: Parallel INSERT (INTO ... SELECT ...)
Next
From: Peter Eisentraut
Date:
Subject: Re: Add primary keys to system catalogs