BUG #7636: \ef doesn't honor ON_ERROR_ROLLBACK
The following bug has been logged on the website:
Bug reference: 7636
Logged by: Marko Tiikkaja
Email address: pgmail@joh.to
PostgreSQL version: 9.1.6
Operating system: OSX something
Description:
Hi,
It looks like \ef doesn't honor ON_ERROR_ROLLBACK:
=# \set ON_ERROR_ROLLBACK true
=# BEGIN;
BEGIN
=# \ef error
ERROR: function "error" does not exist
=# select 1;
ERROR: current transaction is aborted, commands ignored until end of
transaction block
On Thu, Nov 1, 2012 at 02:04:56PM +0000, pgmail@joh.to wrote:
The following bug has been logged on the website:
Bug reference: 7636
Logged by: Marko Tiikkaja
Email address: pgmail@joh.to
PostgreSQL version: 9.1.6
Operating system: OSX something
Description:Hi,
It looks like \ef doesn't honor ON_ERROR_ROLLBACK:
=# \set ON_ERROR_ROLLBACK true
=# BEGIN;
BEGIN
=# \ef error
ERROR: function "error" does not exist
=# select 1;
ERROR: current transaction is aborted, commands ignored until end of
transaction block
I think ON_ERROR_ROLLBACK only controls errors in user queries, not
errors in psql operations. Sorry.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs