Re: after trigger question

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.