bug in on_error_rollback !? - Mailing list pgsql-hackers

<span style="font-family: courier new,monospace;">I was thinking of recommending this to someone, but wanted to try it
onmy own first; good thing that I did. I think it is broken as of now.<br /><br />I assume that the error thrown for
'select1', inside a transaction, with 'on_error_rollback on', is not supposed to raise it's head !!! </span><br
style="font-family:courier new,monospace;" /><br style="font-family: courier new,monospace;" /><span
style="font-family:courier new,monospace;">Or am I missing something?</span><br style="font-family: courier
new,monospace;"/><br style="font-family: courier new,monospace;" /><span style="font-family: courier
new,monospace;">postgres=#select version();</span><br style="font-family: courier new,monospace;" /><span
style="font-family:courier new,monospace;">                                                 version</span><br
style="font-family:courier new,monospace;" /><br style="font-family: courier new,monospace;" /><span
style="font-family:courier
new,monospace;">--------------------------------------------------------------------------------------------------------
</span><brstyle="font-family: courier new,monospace;" /><span style="font-family: courier new,monospace;"> PostgreSQL
8.2beta1on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mingw special 20030504-1)</span><br
style="font-family:courier new,monospace;" /><span style="font-family: courier new,monospace;">(1 row)</span><br
style="font-family:courier new,monospace;" /><br style="font-family: courier new,monospace;" /><span
style="font-family:courier new,monospace;">postgres=# begin; </span><br style="font-family: courier new,monospace;"
/><spanstyle="font-family: courier new,monospace;">BEGIN</span><br style="font-family: courier new,monospace;" /><span
style="font-family:courier new,monospace;">postgres=# \set on_error_rollback on </span><br style="font-family: courier
new,monospace;"/><span style="font-family: courier new,monospace;">postgres=# select a;</span><br style="font-family:
couriernew,monospace;" /><span style="font-family: courier new,monospace;"> ERROR:  column "a" does not exist</span><br
style="font-family:courier new,monospace;" /><span style="font-family: courier new,monospace;">LINE 1: select
a;</span><brstyle="font-family: courier new,monospace;" /><span style="font-family: courier new,monospace;">
              ^</span><br style="font-family: courier new,monospace;" /><span style="font-family: courier
new,monospace;">postgres=#select 1;</span><br style="font-family: courier new,monospace;" /><span style="font-family:
couriernew,monospace;"> ERROR:  current transaction is aborted, commands ignored until end of transaction
block</span><brstyle="font-family: courier new,monospace;" /><span style="font-family: courier
new,monospace;">postgres=#end;</span><br style="font-family: courier new,monospace;" /><span style="font-family:
couriernew,monospace;">ROLLBACK</span><br style="font-family: courier new,monospace;" /><span style="font-family:
couriernew,monospace;">postgres=# select a;</span><br style="font-family: courier new,monospace;" /><span
style="font-family:courier new,monospace;">ERROR:  column "a" does not exist</span><br style="font-family: courier
new,monospace;"/><span style="font-family: courier new,monospace;">LINE 1: select a;</span><br style="font-family:
couriernew,monospace;" /><span style="font-family: courier new,monospace;">               ^</span><br
style="font-family:courier new,monospace;" /><span style="font-family: courier new,monospace;">postgres=# select 1;
</span><brstyle="font-family: courier new,monospace;" /><span style="font-family: courier
new,monospace;"> ?column?</span><brstyle="font-family: courier new,monospace;" /><span style="font-family: courier
new,monospace;">----------</span><br style="font-family: courier new,monospace;" /><span style="font-family: courier
new,monospace;">       1</span><br style="font-family: courier new,monospace;" /><span style="font-family: courier
new,monospace;">(1row) </span><br style="font-family: courier new,monospace;" /><br style="font-family: courier
new,monospace;"/><span style="font-family: courier new,monospace;">postgres=#</span><br style="font-family: courier
new,monospace;"/><br clear="all" style="font-family: courier new,monospace;" /><br style="font-family: courier
new,monospace;"/><span style="font-family: courier new,monospace;">-- </span><br style="font-family: courier
new,monospace;"/><span style="font-family: courier new,monospace;">gurjeet[.singh]@ EnterpriseDB.com</span><br
style="font-family:courier new,monospace;" /><span style="font-family: courier new,monospace;">singh.gurjeet@{ gmail |
hotmail| yahoo }.com </span>