Re: set in transaction - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: set in transaction
Date
Msg-id 20021204034424.GA23234@wolff.to
Whole thread Raw
In response to set in transaction  (Joseph Shraibman <jks@selectacast.net>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Drop column and Access
Next
From: "Dave Best"
Date:
Subject: Re: Postgresql -- initial impressions and comments