ROLLBACK_PREPARED(7pg13)

💅 ROLLBACK PREPARED(7) — the prepared-transaction undo button 💅

okay so this is the ROLLBACK_PREPARED(7pg13) page, straight from the PostgreSQL 13.23 Documentation. she's giving official docs but make it group chat. 💖

✨ NAME ✨

ROLLBACK_PREPARED — cancel a transaction that was earlier prepared for two-phase commit. no cap, that's the whole name vibe. 🫶

🎀 SYNOPSIS 🎀

ROLLBACK PREPARED transaction_id

🌸 DESCRIPTION 🌸

okay so ROLLBACK PREPARED rolls back a transaction that is in prepared state. that's it. that's the assignment. 💅

🦋 PARAMETERS 🦋

• transaction_id — the transaction identifier of the transaction that is to be rolled back. literally which prepared transaction you're rolling back. 🕳️

🔥 NOTES 🔥

• to roll back a prepared transaction, you must be either the same user that executed the transaction originally, or a superuser. but plot twist: you do not have to be in the same session that executed the transaction. bestie can be elsewhere. 🫶
• this command cannot be executed inside a transaction block. nope. not allowed. the prepared transaction is rolled back immediately. no waiting around. ⚡
• all currently available prepared transactions are listed in the pg_prepared_xacts system view. that's your little directory of prepared-transaction girlies. 👑

warning bestie: don't try to run this inside a transaction block — it's literally not allowed. 🙈

🍓 EXAMPLES 🍓

roll back the transaction identified by the transaction identifier foobar:

ROLLBACK PREPARED 'foobar';

🌈 COMPATIBILITY 🌈

ROLLBACK PREPARED is a PostgreSQL extension. it's intended for use by external transaction management systems, some of which are covered by standards (such as X/Open XA), but the SQL side of those systems is not standardized. so like, standards girlies exist but the SQL part is not giving standardized. iykyk. 💀

👑 SEE ALSO 👑

• PREPARE TRANSACTION (PREPARE_TRANSACTION(7))
• COMMIT PREPARED (COMMIT_PREPARED(7))

these are your besties for the two-phase commit saga. go read them. 📚

mwah 💋 — this page is from PostgreSQL 13.23, dated 2025. periodt. 🎀