Re: after trigger question

Stephan Szabo wrote:

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

The conversion of a timestring to an integer value fails because it is
sometimes illegal formatted , but I would like to have the the original
data inserted in the table as a string.

--
Feite Brekeveld
feite.brekeveld@osiris-it.nl