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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])