abort(7) [redhat man page]

ABORT(7)							   SQL Commands 							  ABORT(7)

NAME

       ABORT - abort the current transaction

SYNOPSIS

       ABORT [ WORK | TRANSACTION ]

   INPUTS
       None.

   OUTPUTS
       ROLLBACK
	      Message returned if successful.

       WARNING: ROLLBACK: no transaction in progress
	      If there is not any transaction currently in progress.

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 SQL92 command ROLLBACK, and is present only for historical reasons.

   NOTES
       Use COMMIT to successfully terminate a transaction.

USAGE

       To abort all changes:

       ABORT WORK;

COMPATIBILITY

   SQL92
       This command is a PostgreSQL extension present for historical reasons. ROLLBACK is the SQL92 equivalent command.

SQL - Language Statements					    2002-11-22								  ABORT(7)

END(7)								   SQL Commands 							    END(7)

NAME

       END - commit the current transaction

SYNOPSIS

       END [ WORK | TRANSACTION ]

DESCRIPTION

       END  commits  the  current  transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
       crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT [commit(7)].

PARAMETERS

       WORK

       TRANSACTION
	      Optional key words. They have no effect.

NOTES

       Use ROLLBACK [rollback(7)] to abort a transaction.

       Issuing END when not inside a transaction does no harm, but it will provoke a warning message.

EXAMPLES

       To commit the current transaction and make all changes permanent:

       END;

COMPATIBILITY

       END is a PostgreSQL extension that provides functionality equivalent to COMMIT [commit(7)], which is specified in the SQL standard.

SEE ALSO

       BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)]

SQL - Language Statements					    2010-05-14								    END(7)