Trigger / rule question

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "Pgsql-sql(at)postgresql(dot)org" <Pgsql-sql(at)postgresql(dot)org>
Subject: Trigger / rule question
Date: 2005-11-20 09:18:00
Message-ID: 1132478280.17919.10.camel@Panoramix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Are a trigger or rule part of a query, that is:

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?
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?

TIA

--
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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2005-11-20 10:35:07 Re: Create Public Schema
Previous Message Andreas Kretschmer 2005-11-20 08:49:39 Re: Create Public Schema