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

From Peter Eisentraut
Subject Re: Trigger / rule question
Date
Msg-id 200511201208.00599.peter_e@gmx.net
Whole thread Raw
In response to Trigger / rule question  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Responses Re: Trigger / rule question
List pgsql-sql
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

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Is it possible to redirect an update/insert/delete to a different table?
Next
From: Jaime Casanova
Date:
Subject: Re: Is it possible to redirect an update/insert/delete to a different table?