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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Allow foreign keys to reference a superset of unique columns
Дата
Msg-id bdd9b068-e6ec-1227-1b73-a74773159590@enterprisedb.com
обсуждение исходный текст
Ответ на Allow foreign keys to reference a superset of unique columns  (Kaiting Chen <ktchen14@gmail.com>)
Ответы Re: Allow foreign keys to reference a superset of unique columns  (David Rowley <dgrowleyml@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Collation version tracking for macOS
Следующее
От: David Rowley
Дата:
Сообщение: Re: Allow foreign keys to reference a superset of unique columns