3 ms·
Please add [2014]. I should note that this is not Postres specific - any MVCC ACID database will behave this way. Some use locks instead of MVCC and behave dif
by glogla 10y ago
Please add [2014].
I should note that this is not Postres specific - any MVCC ACID database will behave this way. Some use locks instead of MVCC and behave differently. But it definitely belongs into "What every programmer should know about transactions, ollected works".
- kornish 10y agoSorry, my ability to edit the title expired - but maybe dang can add it. Yeah, this definitely belongs in the essentials. Lots of developers treat transactions as a race condition panacea. This article is a nice case study about how expressing relative SQL transformations (e.g. "subtract 100 from current value") using absolute values ("set the value to 200"), even absolute values derived from relative application logic, can be prone to fault.
- godmodus 10y agoid like to read such a collected works :o