Re: [PATCHES] Bug in psql (on_error_rollback)

2005-09-20 Thread Bruce Momjian
Good patch. You are right that the original code did not consider that AUTOCOMMIT would change the transaction state seen by the ON_ERROR_ROLLBACK check. Fixed in CVS. ON_ERROR_ROLLBACK was not in 8.0.X so no need to backpatch. ---

[PATCHES] Bug in psql (on_error_rollback)

2005-09-16 Thread Michael Paesold
There is a bug in psql for the new ON_ERROR_ROLLBACK feature. In AUTOCOMMIT off mode it does not work correctly for the first statement. This is how it works usually: postgres=# \set AUTOCOMMIT off postgres=# \set ON_ERROR_ROLLBACK interactive postgres=# SELE