Re: Rule ON DELETE, to perform to DELETE querys !

Sorry, but it wasn't this list that i wanted to send this post !!

I already send it to pgsql-sql@postgresql.org !!

Luis Sousa wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster