Re: Trigger / rule question - Mailing list pgsql-sql

From Joost Kraaijeveld
Subject Re: Trigger / rule question
Date
Msg-id 1132500990.17919.34.camel@Panoramix
Whole thread Raw
In response to Re: Trigger / rule question  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Hi Peter,

On Sun, 2005-11-20 at 12:08 +0100, Peter Eisentraut wrote:
> Joost Kraaijeveld wrote:
> > 1. Does an insert, update or delete statement return before or after
> > an "After" trigger (is such a trigger or rule synchronous or
> > a-synchronous?
> 
> Synchronous
> 
> > 2. Is there a concept of a rule or trigger that fails? 
> > If so, if a trigger or rule fails, does the insert, update or delete
> > statement (transaction)  fail?
> 
> Yes
OK, thanks for the answer.

-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl 




pgsql-sql by date:

Previous
From: Andy Ballingall
Date:
Subject: Re: Is it possible to redirect an update/insert/delete to a different table?
Next
From: Andy Ballingall
Date:
Subject: Re: Is it possible to redirect an update/insert/delete to a different table?