Re: why are my SELECTs in transaction?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: why are my SELECTs in transaction?
Дата
Msg-id Pine.LNX.4.44.0306190033010.2501-100000@peter.localdomain
обсуждение исходный текст
Ответ на why are my SELECTs in transaction?  (Travis Hume <travis.hume@tenzing.com>)
Ответы Re: why are my SELECTs in transaction?  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список 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@gmx.net


В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: A creepy story about dates. How to prevent it?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: explicit joins vs implicit joins