Re: why are my SELECTs in transaction? - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: why are my SELECTs in transaction?
Date
Msg-id Pine.LNX.4.21.0306191524050.29248-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Re: why are my SELECTs in transaction?  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: A creepy story about dates. How to prevent it?
Next
From: Paul Thomas
Date:
Subject: Re: FW: Allowing user to connect to a database?