On 2/9/07, Alvaro Herrera <[EMAIL PROTECTED]> 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, -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | yahoo }.com