Re: Delete triggers - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Delete triggers
Date
Msg-id 28449.1049382288@sss.pgh.pa.us
Whole thread Raw
In response to Delete triggers  ("Mathew Frank" <mathewfrank@qushi.com>)
List pgsql-bugs
"Mathew Frank" <mathewfrank@qushi.com> writes:
> The documentation on this is very thin on the ground - I`ve just spend 4 Ho=
> urs googling and the best I could find was one of the main developers (Bruc=
> e?? sorry - too long ago) replying to an email in 2001.    Which was to NOT=
>  cancel the delete operation, you need to return NEW or OLD.

There is no NEW row in a delete trigger.  RETURN OLD should work.

>  - If I return OLD the operation is cancelled ("DELETE 0").

I suspect pilot error.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Mathew Frank"
Date:
Subject: Delete triggers
Next
From: Stephan Szabo
Date:
Subject: Re: Bug #931: bugs "create user" "alter user"