Re: why are my SELECTs in transaction?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Travis Hume <travis(dot)hume(at)tenzing(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why are my SELECTs in transaction?
Date: 2003-06-19 13:53:03
Message-ID: Pine.LNX.4.44.0306190033010.2501-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmx(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-19 13:56:03 Re: explicit joins vs implicit joins
Previous Message Peter Eisentraut 2003-06-19 13:52:26 Re: A creepy story about dates. How to prevent it?