suse man page for abort

Query: abort

OS: suse

Section: 7

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

ABORT(7)							   SQL Commands 							  ABORT(7)

NAME
ABORT - abort the current transaction
SYNOPSIS
ABORT [ WORK | TRANSACTION ]
DESCRIPTION
ABORT rolls back the current transaction and causes all the updates made by the transaction to be discarded. This command is identical in behavior to the standard SQL command ROLLBACK [rollback(7)], and is present only for historical reasons.
PARAMETERS
WORK TRANSACTION Optional key words. They have no effect.
NOTES
Use COMMIT [commit(7)] to successfully terminate a transaction. Issuing ABORT when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To abort all changes: ABORT;
COMPATIBILITY
This command is a PostgreSQL extension present for historical reasons. ROLLBACK is the equivalent standard SQL command.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)] SQL - Language Statements 2010-05-14 ABORT(7)
Related Man Pages
abort(7) - suse
end(7) - suse
start_transaction(7) - suse
rollback(7) - minix
begin(7) - netbsd
Similar Topics in the Unix Linux Community
Roll back problem
Have we just had a rollback of a few hours?
ZoneMan 0.1.0 (Default branch)
SQL in Unix
SQL Functions - PostgreSQL