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 bdd9b068-e6ec-1227-1b73-a74773159590@enterprisedb.com
Whole thread Raw
In response to Allow foreign keys to reference a superset of unique columns  (Kaiting Chen <ktchen14@gmail.com>)
Responses Re: Allow foreign keys to reference a superset of unique columns
List pgsql-hackers
On 07.06.22 20:59, Kaiting Chen wrote:
> 2. The FOREIGN KEY constraint syntax gains a [ USING INDEX index_name ] clause
>     optionally following the referenced column list.
> 
>     The index specified by this clause is used to support the foreign key
>     constraint, and it must be a non-deferrable unique or primary key index on
>     the referenced table compatible with the referenced columns.
> 
>     Here, compatible means that the columns of the index are a subset (the same,
>     or a strict subset) of the referenced columns.

I think this should be referring to constraint name, not an index name.



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Collation version tracking for macOS
Next
From: David Rowley
Date:
Subject: Re: Allow foreign keys to reference a superset of unique columns