News for hackers. Stuff that matters.
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..

There are no comments on this comment yet.