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