Re: problem with new autocommit config parameter and jdbc - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: problem with new autocommit config parameter and jdbc
Date
Msg-id 1031605427.268.160.camel@jester
Whole thread Raw
In response to Re: problem with new autocommit config parameter and jdbc  (snpe <snpe@snpe.co.yu>)
Responses Re: problem with new autocommit config parameter and jdbc  (snpe <snpe@snpe.co.yu>)
List 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



pgsql-hackers by date:

Previous
From: Laurette Cisneros
Date:
Subject: Re:
Next
From: Tom Lane
Date:
Subject: Re: Script to compute random page cost