ROLLBACK(7)

💅 NAME 💅

okay bestie, welcome to ROLLBACK(7) from the PostgreSQL 15.19 Documentation ✨ this one is literally about aborting the current transaction 🫶

🌸 SYNOPSIS 🌸

ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]

🎀 DESCRIPTION 🎀

ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded. it's giving “undo era” and honestly? iconic 💖

🦋 PARAMETERS 🦋

• WORK, TRANSACTION — optional key words, bestie. they have no effect. literally just vibes ✨
• AND CHAIN — if AND CHAIN is specified, a new transaction is immediately started with the same transaction characteristics (see SET TRANSACTION (SET_TRANSACTION(7))) as the just finished one. otherwise, no new transaction is started. periodt 💅

🔥 NOTES 🔥

use COMMIT to successfully terminate a transaction 👑

issuing ROLLBACK outside of a transaction block emits a warning and otherwise has no effect. no cap.

🚨 ROLLBACK AND CHAIN outside of a transaction block is an error. not a vibe, fr fr 😭

🌈 EXAMPLES 🌈

to abort all changes:

ROLLBACK;

⭐ COMPATIBILITY ⭐

the command ROLLBACK conforms to the SQL standard. the form ROLLBACK TRANSACTION is a PostgreSQL extension 👑

💜 SEE ALSO 💜

• BEGIN(7)
• COMMIT(7)
• ROLLBACK TO SAVEPOINT (ROLLBACK_TO_SAVEPOINT(7))

---

signing off with PostgreSQL 15.19 Documentation energy, dated 2026 — mwah, slay, bye bestie 🎀💋🫶