Re: Foreign key joins revisited - Mailing list pgsql-hackers

From Isaac Morland
Subject Re: Foreign key joins revisited
Date
Msg-id CAMsGm5eQBAsHERR7fKgYrTDa=9SMmcDmMZ=0U+G8AZ_SAQHvMw@mail.gmail.com
Whole thread Raw
In response to Re: Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
Responses Re: Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
On Mon, 27 Dec 2021 at 10:20, Joel Jacobson <joel@compiler.org> wrote:
 
Foreign key constraint names have been given the same names as the referenced tables.

While I agree this could be a simple approach in many real cases for having easy to understand FK constraint names, I wonder if for illustration and explaining the feature if it might work better to use names that are completely unique so that it's crystal clear that the names are constraint names, not table names.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: why does reindex invalidate relcache without modifying system tables
Next
From: Justin Pryzby
Date:
Subject: default to to ON_ERROR_STOP=on (Re: psql: exit status with multiple -c and -f)