Re: why are my SELECTs in transaction?

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