October 2001
Beginner to intermediate
400 pages
7h 45m
English
The following pages comprise an alphabetical listing of the SQL commands supported in PostgreSQL (Version 7.1).
ABORT [WORK | TRANSACTION]
ABORT is used to halt a transaction in process and roll back the table(s) to its original state.
None. WORK and TRANSACTION are optional and have no effect.
ROLLBACK (Message returned if successful.)
NOTICE: ROLLBACK: no transaction in process (Returned if no transaction is in process.)
Must be used within a BEGIN…COMMIT series.
Not used in SQL-92; use ROLLBACK instead.
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 ...
Read now
Unlock full access