BUG #7636: \ef doesn't honor ON_ERROR_ROLLBACK

Started by Marko Tiikkajaover 13 years ago2 messagesbugs
Jump to latest
#1Marko Tiikkaja
marko@joh.to

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Marko Tiikkaja (#1)
Re: BUG #7636: \ef doesn't honor ON_ERROR_ROLLBACK

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