Re:An UPDATE without a WHERE, or something close to it
by matsemann on Friday October 29, 2021 @03:36PM
(#29042654)
I've also often used transactions to play it safe.
But our team learned the hard way that using transactions on the replica pg database actually locks it from getting updates globally during the duration of the transaction. And the whole idea of connecting to the replica was to not wreak havoc, oh well..
But our team learned the hard way that using transactions on the replica pg database actually locks it from getting updates globally during the duration of the transaction. And the whole idea of connecting to the replica was to not wreak havoc, oh well..