Re: Allow foreign keys to reference a superset of unique columns - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Allow foreign keys to reference a superset of unique columns
Date
Msg-id 69444397-d537-5276-92be-8930df278098@enterprisedb.com
Whole thread Raw
In response to Re: Allow foreign keys to reference a superset of unique columns  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Allow foreign keys to reference a superset of unique columns  (David Rowley <dgrowleyml@gmail.com>)
Re: Allow foreign keys to reference a superset of unique columns  (Kaiting Chen <ktchen14@gmail.com>)
List pgsql-hackers
On 10.06.22 05:47, David Rowley wrote:
>> I think this should be referring to constraint name, not an index name.
> Can you explain why you think that?

If you wanted to specify this feature in the SQL standard (I'm not 
proposing that, but it seems plausible), then you need to deal in terms 
of constraints, not indexes.  Maybe referring to an index directly could 
be a backup option if desired, but I don't see why that would be 
necessary, since you can easily create a real constraint on top of an index.



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Allow foreign keys to reference a superset of unique columns
Next
From: Amit Kapila
Date:
Subject: Re: Multi-Master Logical Replication