Re: set in transaction

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: set in transaction
Дата
Msg-id 20021204034424.GA23234@wolff.to
обсуждение исходный текст
Ответ на set in transaction  (Joseph Shraibman <jks@selectacast.net>)
Список pgsql-general
On Tue, Dec 03, 2002 at 20:01:56 -0500,
  Joseph Shraibman <jks@selectacast.net> wrote:
> I have a query that performs much better using
> set enable_seqscan = false; The problem is that variables sets don't get
> rolled back when a transaction aborts, so I'm forced to destroy my db
> connection rather than putting it back in the pool. Is there any way around
> this in general other than just setting enable_seqscan = true; and the end?

They do in 7.3.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Drop column and Access
Следующее
От: "Dave Best"
Дата:
Сообщение: Re: Postgresql -- initial impressions and comments