Re: after trigger question

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: after trigger question
Date: 2001-03-21 23:28:23
Message-ID: Pine.BSF.4.21.0103211527070.37102-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Hallstrom 2001-03-21 23:41:20 ERROR: RemoveOperator: left unary operator '~' taking 'int2' does not ????
Previous Message Christian Marschalek 2001-03-21 22:55:41 RE: $PGDATA problem