COMMIT, ROLLBACK, and Autocommit: PostgreSQL Transactions for SQL Server DBAs

· by · in

SQL Server DBAs lean on the ‘run to the SELECT, then COMMIT or ROLLBACK by hand’ workflow. PostgreSQL’s autocommit, abort-on-error, and plpgsql change the rules. Here is how to get the same safety and diagnostics in psql and pgAdmin.