From: "Feite Brekeveld" <[EMAIL PROTECTED]> > 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. Use a BEFORE INSERT trigger then to check/translate the timestring before you insert. - Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster