Re: Unable to Delete a Row - Mailing list pgsql-novice

From Tom Lane
Subject Re: Unable to Delete a Row
Date
Msg-id 2474.1117056352@sss.pgh.pa.us
Whole thread Raw
In response to Re: Unable to Delete a Row  ("Derrick Betts" <derrick@grifflink.com>)
List pgsql-novice
"Derrick Betts" <derrick@grifflink.com> writes:
> I think that you need to "RETURN NEW;" in your tg_remove_contact()
> function rather than "RETURN NULL;"

Actually, since it's a DELETE trigger, there is no NEW row;
he needs to RETURN OLD, instead, to give permission for the delete
to continue.

Given what the trigger is doing (ie, propagating the update to another
table), he might be better off to use an AFTER DELETE trigger instead
of BEFORE DELETE anyway --- in which case the return value doesn't
matter and so RETURN NULL is fine.  The point of AFTER DELETE is that
you can be certain the delete really did happen, and wasn't cancelled
by some other BEFORE DELETE trigger.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Glauter Moulin Coelho"
Date:
Subject: Re: Migration from MySQL
Next
From: John DeSoi
Date:
Subject: Re: ERROR: relation "default_cols" does not exist