Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
ROLLBACK(7)		PostgreSQL 9.6.3 Documentation		   ROLLBACK(7)

NAME
       ROLLBACK	- abort	the current transaction

SYNOPSIS
       ROLLBACK	[ WORK | TRANSACTION ]

DESCRIPTION
       ROLLBACK	rolls back the current transaction and causes all the updates
       made by the transaction to be discarded.

PARAMETERS
       WORK
       TRANSACTION
	   Optional key	words. They have no effect.

NOTES
       Use COMMIT(7) to	successfully terminate a transaction.

       Issuing ROLLBACK	outside	of a transaction block emits a warning and
       otherwise has no	effect.

EXAMPLES
       To abort	all changes:

	   ROLLBACK;

COMPATIBILITY
       The SQL standard	only specifies the two forms ROLLBACK and ROLLBACK
       WORK. Otherwise,	this command is	fully conforming.

SEE ALSO
       BEGIN(7), COMMIT(7), ROLLBACK TO	SAVEPOINT (ROLLBACK_TO_SAVEPOINT(7))

PostgreSQL 9.6.3		     2017			   ROLLBACK(7)

NAME | SYNOPSIS | DESCRIPTION | PARAMETERS | NOTES | EXAMPLES | COMPATIBILITY | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=ROLLBACK&sektion=7&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help