constraint deferred but fails?
От | Nagy László Zsolt |
---|---|
Тема | constraint deferred but fails? |
Дата | |
Msg-id | 7db1a61c-1f0e-d233-0756-b7eecf2f420d@shopzeus.com обсуждение исходный текст |
Ответы |
Re: constraint deferred but fails?
Re: constraint deferred but fails? Re: constraint deferred but fails? |
Список | pgsql-admin |
Hello, I have deferred the only fk constraint to this table inside a transaction, but I still cannot delete rows from it. How is that possible? master=> ALTER TABLE doc.display_mode disable trigger user; ALTER TABLE master=> BEGIN; BEGIN master=> SET CONSTRAINTS doc.fk_book_display_mode_id DEFERRED; SET CONSTRAINTS master=> DELETE FROM doc.display_mode; ERROR: update or delete on table "display_mode" violates foreign key constraint "fk_book_display_mode_id" on table "book" DETAIL: Key (id)=(1) is still referenced from table "book". master=>
В списке pgsql-admin по дате отправления: