Re: altering a column's collation leaves an invalid foreign key

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: altering a column's collation leaves an invalid foreign key
Дата
Msg-id 216627.1717791128@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: altering a column's collation leaves an invalid foreign key  (jian he <jian.universality@gmail.com>)
Ответы Re: altering a column's collation leaves an invalid foreign key  (jian he <jian.universality@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
jian he <jian.universality@gmail.com> writes:
>> * in TryReuseForeignKey, we can pass the information that our primary
>> key old collation is nondeterministic
>> and old collation != new collation to the foreign key constraint.

I have a basic question about this: why are we allowing FKs to be
based on nondeterministic collations at all?  ISTM that that breaks
the assumption that there is exactly one referenced row for any
referencing row.

            regards, tom lane

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: PgStat_KindInfo.named_on_disk not required in shared stats