Rule ON DELETE, to perform to DELETE querys ! - Mailing list pgsql-sql

From Luis Sousa
Subject Rule ON DELETE, to perform to DELETE querys !
Date
Msg-id 3B20EF24.7EE0CD77@ualg.pt
Whole thread Raw
Responses Re: Rule ON DELETE, to perform to DELETE querys !
List 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
WHEREid = 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-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards
Next
From: Jonathan Bartlett
Date:
Subject: Re: maximum number of rows in table - what about oid limits?