Rule ON DELETE, to perform to DELETE querys !

From: Luis Sousa <llsousa(at)ualg(dot)pt>
To: pgsql sql Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Rule ON DELETE, to perform to DELETE querys !
Date: 2001-06-08 15:28:36
Message-ID: 3B20EF24.7EE0CD77@ualg.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-06-08 15:33:07 Re: behavior of ' = NULL' vs. MySQL vs. Standards
Previous Message Jonathan Bartlett 2001-06-08 15:26:57 Re: maximum number of rows in table - what about oid limits?