M
Mike Fechner
Guest
But the explicit lock options on temp-table buffers are not dangerous. But assuming that in case of an error the CREATE is undone on an error thrown by the ASSIGN statement will bite you on the second CREATE and error thrown by the ASSIGN statement because that will end up with a unique index conflict. The explicit DO TRANSACTION shouts: Watch: This entire block will be undone in case of error. But as a matter of fact, that is nothing to get undone.
Continue reading...
Continue reading...