.\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ ROLLBACK PREPARED - Online Linux Manual PageSection : 7
Updated : 2014-02-17
Source : SQL - Language Statements
Note : SQL Commands
NAMEROLLBACK PREPARED − cancel a transaction that was earlier prepared for two-phase commit
SYNOPSISROLLBACK PREPARED transaction_id
DESCRIPTIONROLLBACK PREPARED rolls back a transaction that is in prepared state.
PARAMETERStransaction_id
The transaction identifier of the transaction that is to be rolled back.
NOTESTo roll back a prepared transaction, you must be either the same user that executed the transaction originally, or a superuser. But you do not have to be in the same session that executed the transaction. This command cannot be executed inside a transaction block. The prepared transaction is rolled back immediately. All currently available prepared transactions are listed in the pg_prepared_xacts system view.
EXAMPLESRoll back the transaction identified by the transaction identifier foobar: ROLLBACK PREPARED 'foobar';
SEE ALSOPREPARE TRANSACTION [prepare_transaction(7)], COMMIT PREPARED [commit_prepared(7)] 0
Johanes Gumabo
Data Size : 4,764 byte man-rollback_prepared.7Build : 2024-12-29, 07:25 :
Visitor Screen : 1280 x 720
Visitor Counter ( page / site ) : 2 / 262,913
Visitor ID : :
Visitor IP : 18.191.237.79 :
Visitor Provider : AMAZON-02 :
Provider Position ( lat x lon ) : 39.962500 x -83.006100 : x
Provider Accuracy Radius ( km ) : 1000 :
Provider City : Columbus :
Provider Province : Ohio , : ,
Provider Country : United States :
Provider Continent : North America :
Visitor Recorder : Version :
Visitor Recorder : Library :
Online Linux Manual Page : Version : Online Linux Manual Page - Fedora.40 - march=x86-64 - mtune=generic - 24.12.29
Online Linux Manual Page : Library : lib_c - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Online Linux Manual Page : Library : lib_m - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Data Base : Version : Online Linux Manual Page Database - 24.04.13 - march=x86-64 - mtune=generic - fedora-38
Data Base : Library : lib_c - 23.02.07 - march=x86-64 - mtune=generic - fedora.36
Very long time ago, I have the best tutor, Wenzel Svojanovsky . If someone knows the email address of Wenzel Svojanovsky , please send an email to johanes_gumabo@yahoo.co.id .
If error, please print screen and send to johanes_gumabo@yahoo.co.id
Under development. Support me via PayPal.
ERROR : Need New Coding : (rof_escape_sequence|91|rollback_prepared.7|1|\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ |.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $
) (parse_manual_page_|252|rollback_prepared.7|1|\"|.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $
)