On Thu, 19 Jun 2003, Nigel J. Andrews wrote: > On Thu, 19 Jun 2003, Peter Eisentraut wrote: > > > Travis Hume writes: > > > > > So at this point all selects are screwed unless I issue a ROLLBACK; > > > Why? Is there a way for SELECTs (or all SQL) statement that fail to NOT > > > have this behaviour? > > > > You probably set autocommit to off. Turn it on. > > Actually, I've been having a oddity along those lines on 7.3.3 > > Running a script as from a shell scipt as: > > ...
Ah, sorry, I think I might have got confused with an email I saw yesterday. I only glanced at the content of this one before replying making what appear to be some wrong assumptions about the subject matter from the subject line. -- Nigel J. Andrews ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])