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(dot)brekeveld(at)osiris-it(dot)nl