I have a table that has 3 triggers update, insert and delete
I use this triggers to insert changes on the table into a log table
In the insert trigger I have to update the row that was just inserted, this
fires the update trigger. so for an insert I get 2 rows in my log table
To prevent this from happening, I have added a column to the table (sort of
an insert flag) which I switch off in the update.
I don't like this work around it isn't pretty
the question : how do I know in the update trigger not to insert a new
record into the log table?