Re: why it doesn't work? referential integrity

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: why it doesn't work? referential integrity
Дата
Msg-id 162867790708170853mab4303ftaa06836de265fbe5@mail.gmail.com
обсуждение исходный текст
Ответ на Re: why it doesn't work? referential integrity  (Janning Vygen <vygen@planwerk6.de>)
Список pgsql-general
>
> looks strange to me too, but i never had foreign keys to the same table.
> it works if you define your chekced_by FK deferrable with
>
> checked_by INT REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
> DEFERRABLE INITIALLY DEFERRED,
>
> it seams that postgresql does its job in a procedural way instead of
> relational.
>

It is solved. It was PostgreSQL bug repaired
http://archives.postgresql.org/pgsql-committers/2007-08/msg00207.php
Thank you
nice a day
Pavel Stehule

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

Предыдущее
От: Ted Byers
Дата:
Сообщение: Re: [RESEND] Transaction auto-abort causes grief with Spring Framework
Следующее
От: "Phoenix Kiula"
Дата:
Сообщение: FInding "corrupt" values in UTF-8 tables (regexp question, I think)