Re: problem with new autocommit config parameter and jdbc

Rod Taylor <rbt@rbt.ca>

From: Rod Taylor <rbt@rbt.ca>
To: snpe <snpe@snpe.co.yu>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-09-09T21:03:46Z
Lists: pgsql-hackers
On Mon, 2002-09-09 at 17:04, snpe wrote:

> I'm use 'autocommit=false' and have problem with psql
> When any commnad is lost, then next commnad get error for transactions
> (simple select command).BTW
> 
> snpe> select * from org_ba;
> ERROR: relation org_ba does not exists
> snpe> select * from org_ban;
> ERROR: current transactions is aborted, queries ignored until end of 
> transaction block
> snpe> rollback;
> ROLLBACK
> snpe> select * from org_ban;

Maybe I'm missing something, but isn't that the expected behaviour when
autocommit is turned off?
 
-- 
  Rod Taylor