Re: Catching delete - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Catching delete
Date
Msg-id 20050210225157.GB92318@winnie.fuhr.org
Whole thread Raw
In response to Catching delete  (Jamie Deppeler <jamie@doitonce.net.au>)
List pgsql-general
On Fri, Feb 11, 2005 at 09:28:04AM +1100, Jamie Deppeler wrote:
>
> have a pretty simple question i know its possible to catch a delete
> statement through a trigger is it possible to prevent the delete from
> happing through the same trigger function?

The trigger documentation describes how a trigger can affect the
attempted operation:

http://www.postgresql.org/docs/8.0/static/triggers.html
http://www.postgresql.org/docs/8.0/static/plpgsql-trigger.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Understanding EXPLAIN ANALYZE output
Next
From: Michael Fuhr
Date:
Subject: Re: Understanding EXPLAIN ANALYZE output