| From: | "Jean-Francois Leveque" <leveque(at)webmails(dot)com> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Trigger Procedures question |
| Date: | 2001-06-29 16:21:37 |
| Message-ID: | 20010629152137.3713.qmail@webmails.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
from it).
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.
Best regards,
Jean-Francois Leveque
______________________________________________________________________
Sur WebMailS.com, mon adresse de courrier lectronique gratuite.
Service multilingue, sr, et permanent. http://www.webmails.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Sébastien ANDUJAR | 2001-07-03 10:25:41 | replication |
| Previous Message | Weiping He | 2001-06-28 12:42:46 | Re: RE: Hello |