Re: set in transaction

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: set in transaction
Date: 2002-12-04 03:44:24
Message-ID: 20021204034424.GA23234@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 03, 2002 at 20:01:56 -0500,
Joseph Shraibman <jks(at)selectacast(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Manuel Cabido 2002-12-04 04:18:13 Re: PostgreSQL in Universities (Was: Re: 7.4 Wishlist)
Previous Message Adrian Klaver 2002-12-04 03:05:51 Drop column and Access