Re: rollback ignored until end of transaction block - Mailing list pgsql-jdbc

Kris Jurka wrote:
>
>
> On Wed, 23 Nov 2005, Oliver Jowett wrote:
>
>> I just tried against a server built from HEAD and couldn't reproduce
>> the problem any of the obvious ways.. Think we will need a testcase here.
>>
>
> Another idea that occurred to me that I don't have time to test is that
> processDeadParsedQueries or processDeadPortals doesn't like getting run
> in a stalled transaction.

No errors against CVS HEAD with the CloseStatement/ClosePortal messages
being sent after an error, just before the ROLLBACK:

[...]
  <=BE ReadyForQuery(E)
caught expected exception
closing query: select * from pg_proc
simple execute,
handler=org.postgresql.jdbc2.AbstractJdbc2Connection$TransactionCommandHandler@6443226,
maxRows=0, fetchSize=0, flags=22
  FE=> CloseStatement(S_11)
  FE=> ClosePortal(C_12)
  FE=> Bind(stmt=S_4,portal=null)
  FE=> Execute(portal=null,limit=1)
  FE=> Sync
  <=BE CloseComplete
  <=BE CloseComplete
  <=BE BindComplete [null]
  <=BE CommandStatus(ROLLBACK)
  <=BE ReadyForQuery(I)
rollback was ok

-O