ROLLBACK(7)

🌸 NAME 🌸

ROLLBACK(7) — abort the current transaction. That's it, that's the whole job, and honestly? iconic. 💅 This page is from the PostgreSQL 16.15 docs, bestie. 🫶

✨ 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. translation: it's the undo button for the current transaction. all those updates? gone. discarded. not invited to the afterparty. 😭

🎀 PARAMETERS 🎀

• WORK — optional keyword. it has no effect. literally decorative. ✨
• TRANSACTION — optional keyword. same deal: no effect. 💅
• AND CHAIN — if AND CHAIN is specified, a new (not aborted) 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. no cap, that's the whole rule. 🔥

💖 NOTES 💖

Use COMMIT to successfully terminate a transaction. that's the "actually save it" bestie. ✅

Issuing ROLLBACK outside of a transaction block emits a warning and otherwise has no effect. so: warning, then nothing. lowkey awkward. 🙈

ROLLBACK AND CHAIN outside of a transaction block is an error. not a warning. an actual error. 💀

🌈 EXAMPLES 🌈

To abort all changes:

ROLLBACK;

👑 COMPATIBILITY 👑

The command ROLLBACK conforms to the SQL standard. The form ROLLBACK TRANSACTION is a PostgreSQL extension. so the first one is standard-coded, the second one is a PostgreSQL-only little extra. 🎀

🧚 SEE ALSO 🧚

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

---

mwah 💋 this page is PostgreSQL 16.15, dated 2026, and it's the ROLLBACK(7) manual page. go forth and undo responsibly, bestie. periodt 🫶✨