Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types

Поиск
Список
Период
Сортировка
От Marcus Gartner
Тема Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types
Дата
Msg-id CAJ2Nfu_xVpV5gZYu04scKbizOgSNVF7AEEtwo7u1S64KiZY8hg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-bugs
Дерево обсуждения
I agree with you there. So why is an FK relationship between columns of different types even allowed?

On Mon, Nov 1, 2021 at 5:59 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
PG Bug reporting form <noreply@postgresql.org> writes:
> It is possible to break foreign key referential integrity when the FK
> columns have different types and updates are cascaded from the parent
> relation to the child relation.

I'm not really sure what you'd consider such an FK relationship to mean.
I can't get too excited about it when there doesn't seem to be a well
defined semantics for it.

                        regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types