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 по дате отправления: