Message-ID: <20010629152137.3713.qmail@webmails.com>
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
From: "Jean-Francois Leveque" <leveque@webmails.com>
To: pgsql-docs@postgresql.org
Subject: Trigger Procedures question
Organization: WebMailS - http://www.webmails.com
Date: Fri, 29 Jun 2001 17:21:37 +0100


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/