Re: Trigger / rule question

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)askesis(dot)nl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Trigger / rule question
Date: 2005-11-20 11:08:00
Message-ID: 200511201208.00599.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jaime Casanova 2005-11-20 14:23:29 Re: Is it possible to redirect an update/insert/delete to a different table?
Previous Message Peter Eisentraut 2005-11-20 11:07:00 Re: Is it possible to redirect an update/insert/delete to a different table?