Rule ON DELETE, to perform to DELETE querys !
От | Luis Sousa |
---|---|
Тема | Rule ON DELETE, to perform to DELETE querys ! |
Дата | |
Msg-id | 3B20CF7B.24396094@ualg.pt обсуждение исходный текст |
Ответы |
Re: Rule ON DELETE, to perform to DELETE querys !
Re: Rule ON DELETE, to perform to DELETE querys ! |
Список | pgsql-admin |
I have a view over a join of tables and when it's performed over the view a delete i want to delete records in two different tables. The code that i wrote was: CREATE RULE "deletetables" AS ON DELETE TO "tables" DO INSTEAD ( DELETE FROM table2 WHERE id = OLD.id; DELETE FROM table1 WHERE id=OLD.id ); table2 references table1 by the field id only for update. I don't them to be referenced by delete ! When i execute: DELETE FROM tables WHERE id=1; i got these message from postgres: pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. The records exists in both tables !!!!!!! This already happen with some of you ???? How can i do this ???? Thanks Luis Sousa
В списке pgsql-admin по дате отправления: