hard20 pts · first answer countsdatabasestransactionsconnection-pooling

A transaction spread across connections

Using node-postgres, this 'transaction' sometimes commits half the work. Why?

await pool.query('BEGIN')
await pool.query('UPDATE accounts SET bal = bal - 100 WHERE id = 1')
await pool.query('UPDATE accounts SET bal = bal + 100 WHERE id = 2')
await pool.query('COMMIT')

A.BEGIN is not supported by node-postgresB.COMMIT must be sent before the updatesC.Each pool.query may use a different connectionD.Two UPDATEs cannot be in one transaction

Discussion 0

Join free to post in the discussion.

A transaction spread across connections

Discussion 0

Related questions