Re: BUG #18295: In PostgreSQL a unique index on targeted columns is sufficient to support a foreign key - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18295: In PostgreSQL a unique index on targeted columns is sufficient to support a foreign key
Date
Msg-id CAKFQuwb2u48ZxPHzJi+qR-ADcUUO3vSnU+FJcuN9VVFGe-Ay2Q@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18295: In PostgreSQL a unique index on targeted columns is sufficient to support a foreign key  (gparc@free.fr)
List pgsql-bugs
On Wednesday, January 24, 2024, <gparc@free.fr> wrote:
any comment ?

It isn’t a bug at this point; not something we’d change on model purity grounds.  The user is capable and encouraged to ensure a constraint exists though.  There may be a doc update warranted here but that needs to be looked into by a motivated and available individual.

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #18307: system columns does not support using join
Next
From: Daniel Gustafsson
Date:
Subject: Re: BUG #18309: TOASTed entry in pg_subscription provokes an assertion failure