Trigger firing when it shouldn't [message #725] |
Thu, 28 February 2002 05:35 |
Lee
Messages: 56 Registered: May 1999
|
Member |
|
|
We have a before trigger, "insert or update of col1, col2, col3 on table1 for each row", that is firing when we update col4, even though it is not in the update of clause. If we rebuild the trigger, it behaves correctly.
We accidently discovered the trigger was mis-behaving in production, so we exported the prod db and put it in a test env. The trigger still mis-behaved until we dropped and recreated it.
Anyone experienced this behavior?
The system is 8.1.7 on Win 2000
Thanks,
Lee
|
|
|
|