Re: trigger on DELETE - Mailing list pgsql-sql

From Kristis Makris
Subject Re: trigger on DELETE
Date
Msg-id 200107112323.f6BNNra16872@postgresql.org
Whole thread Raw
In response to trigger on DELETE  (Phuong Ma <pma@commandprompt.com>)
List pgsql-sql
> Ok, the function works only with a trigger that is defined as ON INSERT
> OR UPDATE.  If I try to define a trigger for ON DELETE and then delete a
> row from the table, there is nothing in the 'NEW' variable to return.  I
> get an error message.  If I define the function to return NULL, 0, or
> nothing, then it comes up with a type mis-match error.  Is there anyone
> who can help?  Thanks.


Try using the OLD variable instead.



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: [GENERAL] trigger on DELETE
Next
From: Wei Weng
Date:
Subject: Turn off flushing after each write