From: Jean-Francois Leveque <leveque@webmails.com>
To: pgsql-docs@postgresql.org
Subject: Trigger Procedures question
Date: Fri, 29 Jun 2001 17:21:37 +0100
Message-ID: <20010629152137.3713.qmail@webmails.com> (raw)
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, sûr, et permanent. http://www.webmails.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: leveque@webmails.com
Subject: Re: Trigger Procedures question
In-Reply-To: <20010629152137.3713.qmail@webmails.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox