ROLLBACK(7)

🌸 NAME 🌸

okay so bestie, this is ROLLBACK(7) — the manual page for ROLLBACK, aka abort the current transaction. It’s giving “undo button for the current transaction” energy, and honestly? Iconic. This is the ROLLBACK(7) page from PostgreSQL, so you already know it’s about undoing stuff and discarding updates. Periodt. 💅

✨ 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. That’s the whole main-character move: everything the transaction did gets tossed. No cap. 🫶

🎀 PARAMETERS 🎀

• WORK — optional key word, bestie. It has no effect. Literally zero. 💀
• TRANSACTION — another optional key word. Also no effect. Same energy. ✨
• 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.

🦋 NOTES 🦋

Use COMMIT(7) to successfully terminate a transaction. That’s the “we’re keeping this” girlie. 💖

Issuing ROLLBACK outside of a transaction block emits a warning and otherwise has no effect. ROLLBACK AND CHAIN outside of a transaction block is an error. So like, don’t do the chain thing outside a transaction block — it’s not a vibe. 😭

🌈 EXAMPLES 🌈

To abort all changes:

ROLLBACK;

⭐ COMPATIBILITY ⭐

The command ROLLBACK conforms to the SQL standard. The form ROLLBACK TRANSACTION is a PostgreSQL extension. Slay. 🌟

👑 SEE ALSO 👑

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

---

PostgreSQL 13.23 Documentation · 2025 · ROLLBACK(7) — mwah, bestie 💋🫶