'\" t .\" Title: ROLLBACK .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets vsnapshot .\" Date: 2024 .\" Manual: PostgreSQL 16.2 Documentation .\" Source: PostgreSQL 16.2 .\" Language: English .\" .TH "ROLLBACK" "7" "2024" "PostgreSQL 16.2" "PostgreSQL 16.2 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" ROLLBACK \- abort the current transaction .SH "SYNOPSIS" .sp .nf ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] .fi .SH "DESCRIPTION" .PP \fBROLLBACK\fR rolls back the current transaction and causes all the updates made by the transaction to be discarded\&. .SH "PARAMETERS" .PP WORK .br TRANSACTION .RS 4 Optional key words\&. They have no effect\&. .RE .PP AND CHAIN .RS 4 If AND CHAIN is specified, a new (not aborted) transaction is immediately started with the same transaction characteristics (see SET TRANSACTION (\fBSET_TRANSACTION\fR(7))) as the just finished one\&. Otherwise, no new transaction is started\&. .RE .SH "NOTES" .PP Use \fBCOMMIT\fR to successfully terminate a transaction\&. .PP Issuing \fBROLLBACK\fR outside of a transaction block emits a warning and otherwise has no effect\&. \fBROLLBACK AND CHAIN\fR outside of a transaction block is an error\&. .SH "EXAMPLES" .PP To abort all changes: .sp .if n \{\ .RS 4 .\} .nf ROLLBACK; .fi .if n \{\ .RE .\} .SH "COMPATIBILITY" .PP The command \fBROLLBACK\fR conforms to the SQL standard\&. The form ROLLBACK TRANSACTION is a PostgreSQL extension\&. .SH "SEE ALSO" \fBBEGIN\fR(7), \fBCOMMIT\fR(7), ROLLBACK TO SAVEPOINT (\fBROLLBACK_TO_SAVEPOINT\fR(7))