| From: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Trigger / rule question |
| Date: | 2005-11-20 15:36:30 |
| Message-ID: | 1132500990.17919.34.camel@Panoramix |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Ballingall | 2005-11-20 15:40:41 | Re: Is it possible to redirect an update/insert/delete to a different table? |
| Previous Message | Andy Ballingall | 2005-11-20 15:28:10 | Re: Is it possible to redirect an update/insert/delete to a different table? |