Re: Add primary keys to system catalogs

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>, Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add primary keys to system catalogs
Date: 2021-01-21 07:39:03
Message-ID: de49a11e-b448-1af8-c3ac-e92c0b4e2a7d@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2021-01-21 07:41:04 Re: Add primary keys to system catalogs
Previous Message Greg Nancarrow 2021-01-21 07:34:20 Re: Parallel INSERT (INTO ... SELECT ...)