Alphabetical Listing
The following pages comprise an alphabetical listing of the SQL commands supported in PostgreSQL (Version 7.1).
ABORT
Syntax
ABORT [WORK | TRANSACTION]
Description
ABORT is used to halt a transaction in process and roll back the table(s) to its original state.
Input(s)
None. WORK and TRANSACTION are optional and have no effect.
Output(s)
ROLLBACK (Message returned if successful.)
NOTICE: ROLLBACK: no transaction in process (Returned if no transaction is in process.)
Notes
Must be used within a BEGIN…COMMIT series.
SQL-92 Compatibility
Not used in SQL-92; use ROLLBACK instead.
Example
The following code shows how the ABORT command could be used to halt a transaction in progress and return the table back to its original ...
Get PostgreSQL Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
