Re: Allow foreign keys to reference a superset of unique columns

Thu, 09 Jun 2022 20:08:55 -0700 

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.

Reply via email to