I want to check something before
a delete is made.
I made a before delete trigger that
calls a procedure.
The procedure raises an exception
when I don't want the delete to be
made (I could also have returned NULL,
but wouldn't have get much information
The question is :
What do I return when I want the delete to be made ?
If I return OLD (known when deleting), maybe that
cancels the delete too.
I don't have NEW (known only on insert/update).
I couldn't find the answer in the docs.
Sur WebMailS.com, mon adresse de courrier lectronique gratuite.
Service multilingue, sr, et permanent. http://www.webmails.com/
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2001-07-03 14:02:24|
|Subject: Re: selecting from cursor |
|Previous:||From: Jan Wieck||Date: 2001-07-03 13:46:56|
|Subject: Re: Trigger Procedures question|