On 2/9/07,
Alvaro Herrera <
alvherre@commandprompt.com> wrote:
At least it'd help those poor people trying to do conditional COMMIT or
ROLLBACK based on the transaction status.
The user doesn't need to check the status of the transaction if he just needs to end it. Just fire the END command and it'll take care of whether to COMMIT or ROLLBACK the transaction:
edb=# begin;
BEGIN
edb=# select count(*) from pg_class;
count
-------
280
(1 row)
edb=# select count(*) from pg_class_xyz;
ERROR: relation "pg_class_xyz" does not exist
edb=# end;
ROLLBACK
edb=#
Regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com