Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: why are my SELECTs in transaction?
Date
Msg-id Pine.LNX.4.44.0306190033010.2501-100000@peter.localdomain
Whole thread Raw
In response to why are my SELECTs in transaction?  (Travis Hume <travis.hume@tenzing.com>)
Responses Re: why are my SELECTs in transaction?  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
Tree view 
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.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: A creepy story about dates. How to prevent it?
Next
From: Tom Lane
Date:
Subject: Re: explicit joins vs implicit joins