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