April 13, 2021 at 12:00 am
Comments posted to this topic are about the item Preventing Trigger Execution
April 13, 2021 at 7:37 am
How thread-safe is this? I.e. will other sessions with updates also not fire the trigger?
April 13, 2021 at 8:50 am
Can I just say that I really, really dislike the use of Triggers? I know they have their place, but they are so often improperly documented and, as a consequence, a rich source of bugs.
April 13, 2021 at 6:24 pm
You can wrap it all in a transaction, but everyone who uses the table (and more) will be locked for the duration of your change.
Best to do it during off-peak hours.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy