On Thu, 25 Oct 2001, Fran Fabrizio wrote:
>
> I seem to be observing that on a trigger I've created to fire
> AFTER INSERT, if I intentionally introduce some sort of syntax error to
> the trigger for example, and insert a row, the row does not appear in
> the table, even though I've declared it to fire after insert. Shouldn't
> that row be there regardless of whether the trigger does or does not
> fire successfully? Or is this currently not how it works? The docs
> seemed to indicate that it would work that way.
I think the syntax error is an error condition which will cause a
rollback. Technically, that would mean your row was inserted and then
rolled back.
> The end result is that I need to make sure the insert happens whether or
> not the trigger is successful.
I don't think you can get this right now using triggers.