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

Reply via email to