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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: gparc(at)free(dot)fr
Cc: pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #18295: In PostgreSQL a unique index on targeted columns is sufficient to support a foreign key
Date: 2024-01-26 10:54:52
Message-ID: 87bde9f9c7fe5467617c303e63a380a17f0b2600.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, 2024-01-25 at 16:36 +0100, gparc(at)free(dot)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

Attachment Content-Type Size
v1-0001-Document-that-foreign-keys-can-reference-unique-i.patch text/x-patch 3.7 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2024-01-26 11:33:20 Re: BUG #18295: In PostgreSQL a unique index on targeted columns is sufficient to support a foreign key
Previous Message PG Bug reporting form 2024-01-26 10:06:48 BUG #18312: libpq: PQsetdbLogin() not thread-safe