ABORT(7)

📦 version 14.24, in opensuse-leap 16.0

✨ ABORT(7) — the "nvm bestie, undo" command ✨

okay so this is the glow-up of the ABORT(7) page — your group-chat cheat sheet for yeeting a transaction into the void 💅 no cap. the vibe is: undo the current transaction, discard all its updates, and move on with your life. periodt.

💅 NAME 💅

ABORT — abort the current transaction. that's it, that's the whole name section, bestie 🎀

✨ SYNOPSIS ✨

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

that's the whole incantation, copied exactly, no "fixing" the brackets 🙈

🫶 DESCRIPTION 🫶

ABORT rolls back the current transaction and causes all the updates made by the transaction to be discarded. it's giving "ctrl+z but for a whole transaction" 😭

this command is identical in behavior to the standard SQL command ROLLBACK, and it's present only for historical reasons. so yeah, it's an icon for the lore, not because it's the freshest way to do it 💅

🎀 PARAMETERS 🎀

  • WORK, TRANSACTION — optional key words. they have no effect. literally just there, vibing 🫶
  • AND CHAIN — if AND CHAIN is specified, a new transaction is immediately started with the same transaction characteristics (see SET TRANSACTION) as the just finished one. otherwise, no new transaction is started.
no extra behaviour invented here, bestie — that's exactly what the page says 🔥

🌸 NOTES 🌸

  • use COMMIT to successfully terminate a transaction. ABORT is the "nvm" button, COMMIT is the "ship it" button 💖
  • issuing ABORT outside of a transaction block emits a warning and otherwise has no effect. so if you're not inside a transaction block, it's just gonna warn and do nothing — lowkey not useful, highkey not the moment 💀

🦋 EXAMPLES 🦋

to abort all changes:

ABORT;

slay. that's the example. copy it exactly, semicolon and all ✨

🔥 COMPATIBILITY 🔥

this command is a PostgreSQL extension present for historical reasons. ROLLBACK is the equivalent standard SQL command. iykyk 👑

🌈 SEE ALSO 🌈

go read those too, bestie — they're the rest of the transaction cinematic universe 🎬✨

🎀 that's the whole page, signed, sealed, slayed: PostgreSQL 14.24 documentation, 2026, page ABORT(7) — mwah 💋✨🫶
📦 where this page comes from