Re: why are my SELECTs in transaction?

Поиск
Список
Период
Сортировка
От Nigel J. Andrews
Тема Re: why are my SELECTs in transaction?
Дата
Msg-id Pine.LNX.4.21.0306191524050.29248-100000@ponder.fairway2k.co.uk
обсуждение исходный текст
Ответ на Re: why are my SELECTs in transaction?  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: A creepy story about dates. How to prevent it?
Следующее
От: Paul Thomas
Дата:
Сообщение: Re: FW: Allowing user to connect to a database?