Christof Petig <christof(dot)petig(at)wtal(dot)de> writes:
> During development of a CIM program I frequently updated a table by its
> primary key (int2 or numeric(3)). A lot of strange messages
> 'NOTICE: (transaction aborted): queries ignored until END' alerted me
> that something is going wrong.
> [ details snipped ]
FWIW, the test program you supplied seems to run without errors for me.
I'm using current CVS sources on an HPUX box.
There was a fix applied on 8/8 to clean up a problem with btrees not
recovering from an aborted transaction properly, but I'm not sure
whether that has anything to do with your example...
regards, tom lane