hard20 pts · first answer countstransactionspostgresqlautocommit
Two statements sent in one string
A tool sends "UPDATE a SET x = 1; UPDATE b SET y = 2;" as one simple query string to PostgreSQL, with no BEGIN. The second UPDATE fails. What happens to the first?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Logical vs physical backupDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- Read-only access for analystsDatabase Administrator
- What pg_hba.conf controlsDatabase Administrator
- View vs materialized viewDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- Seeing what is running nowDatabase Administrator