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.