Re: after trigger question - Mailing list pgsql-general

From Stephan Szabo
Subject Re: after trigger question
Date
Msg-id Pine.BSF.4.21.0103211527070.37102-100000@megazone23.bigpanda.com
Whole thread Raw
In response to after trigger question  (Feite Brekeveld <feite.brekeveld@osiris-it.nl>)
Responses ERROR: RemoveOperator: left unary operator '~' taking 'int2' does not ????  (Philip Hallstrom <philip@adhesivemedia.com>)
List pgsql-general
On Thu, 22 Mar 2001, Feite Brekeveld wrote:

> Hi,
>
> I have put an AFTER INSERT  TRIGGER on a table.
>
> If the triggerfunction fails to do an operation shouldn't the insert
> already have taken place ?

It depends on what you mean by fails to do an operation.  If it
raises an actual error the transaction is going to be rolled back so the
insert is effectively undone.


pgsql-general by date:

Previous
From: "Christian Marschalek"
Date:
Subject: RE: $PGDATA problem
Next
From: Philip Hallstrom
Date:
Subject: ERROR: RemoveOperator: left unary operator '~' taking 'int2' does not ????