Horton

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

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: gparc@free.fr, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2024-01-29T21:18:37Z
Lists: pgsql-bugs 
On Mon, 29 Jan 2024 at 21:59, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> Hm.  With your changes, the title reads "Foreign-Key Constraints", but
> the body uses "foreign key constraint".  I think they should be consistent.
>
> I'd be happy with either variant, but since the hyphenated version
> isn't used anywhere else on the page, my opinion is that we should do
> away with it.

OK, I've gone back to doing away with it.

> Other than that, your patch looks good to me.

Thanks. Pushed.

David

Commits

  1. Doc: mention foreign keys can reference unique indexes