Horton

Re: BUG #18295: In PostgreSQL a unique index on targeted columns is sufficient to support a foreign key

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: gparc@free.fr
Cc: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2024-01-26T10:54:52Z
Lists: pgsql-bugs

Attachments

On Thu, 2024-01-25 at 16:36 +0100, gparc@free.fr wrote:
> Is this new wording OK for you ?

There are a few more places that should be updated, among them
the standard conformance of CREATE TABLE.

Attached is my suggested patch.

Yours,
Laurenz Albe

Commits

  1. Doc: mention foreign keys can reference unique indexes