1ABORT()                          SQL Commands                          ABORT()
2
3
4

NAME

6       ABORT - abort the current transaction
7
8

SYNOPSIS

10       ABORT [ WORK | TRANSACTION ]
11
12

DESCRIPTION

14       ABORT  rolls  back  the  current transaction and causes all the updates
15       made by the transaction to be discarded.  This command is identical  in
16       behavior  to  the  standard  SQL command ROLLBACK [rollback(7)], and is
17       present only for historical reasons.
18

PARAMETERS

20       WORK
21
22       TRANSACTION
23              Optional key words. They have no effect.
24

NOTES

26       Use COMMIT [commit(7)] to successfully terminate a transaction.
27
28       Issuing ABORT when not inside a transaction does no harm, but  it  will
29       provoke a warning message.
30

EXAMPLES

32       To abort all changes:
33
34       ABORT;
35
36

COMPATIBILITY

38       This  command is a PostgreSQL extension present for historical reasons.
39       ROLLBACK is the equivalent standard SQL command.
40

SEE ALSO

42       BEGIN [begin(7)], COMMIT [commit(l)], ROLLBACK [rollback(l)]
43
44
45
46SQL - Language Statements         2008-06-08                           ABORT()