Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLtransactions BEGIN COMMITSingle-choice MCQ

Inside a transaction, a statement raises an error but you do not issue ROLLBACK. You then send another query. What happens in standard PostgreSQL?

BEGIN; INSERT INTO t VALUES (1); SELECT 1/0; -- error SELECT * FROM t; -- next statement