release_savepoint.7 - Online Linux Manual Page

.\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ RELEASE SAVEPOINT - Online Linux Manual PageSection : 7
Updated : 2014-02-17
Source : SQL - Language Statements
Note : SQL Commands

NAMERELEASE SAVEPOINT − destroy a previously defined savepoint

SYNOPSISRELEASE [ SAVEPOINT ] savepoint_name

DESCRIPTIONRELEASE SAVEPOINT destroys a savepoint previously defined in the current transaction. Destroying a savepoint makes it unavailable as a rollback point, but it has no other user visible behavior. It does not undo the effects of commands executed after the savepoint was established. (To do that, see ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)].) Destroying a savepoint when it is no longer needed allows the system to reclaim some resources earlier than transaction end. RELEASE SAVEPOINT also destroys all savepoints that were established after the named savepoint was established.

PARAMETERSsavepoint_name The name of the savepoint to destroy.

NOTESSpecifying a savepoint name that was not previously defined is an error. It is not possible to release a savepoint when the transaction is in an aborted state. If multiple savepoints have the same name, only the one that was most recently defined is released.

EXAMPLESTo establish and later destroy a savepoint: BEGIN; INSERT INTO table1 VALUES (3); SAVEPOINT my_savepoint; INSERT INTO table1 VALUES (4); RELEASE SAVEPOINT my_savepoint; COMMIT; The above transaction will insert both 3 and 4.

COMPATIBILITYThis command conforms to the SQL standard. The standard specifies that the key word SAVEPOINT is mandatory, but PostgreSQL allows it to be omitted.

SEE ALSOBEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)], ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)], SAVEPOINT [savepoint(7)] 0

Johanes Gumabo

Data Size : 6,832 byte
man-release_savepoint.7Build : 2024-12-05, 20:55 :
Visitor Screen : x
Visitor Counter ( page / site ) : 2 / 172,618
Visitor ID : :
Visitor IP : 3.137.221.114 :
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.05
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|release_savepoint.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_|249|release_savepoint.7|1|\"|.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ )