Postgres Pro
Downloads
Home   >   mailing lists

Re: proposal: set GUC variables for single query - Mailing list pgsql-hackers

From Tom Lane
Subject Re: proposal: set GUC variables for single query
Date
Msg-id 15599.1318780188@sss.pgh.pa.us
Whole thread Raw
In response to proposal: set GUC variables for single query  (Jan Urbański <wulczer@wulczer.org>)
Responses Re: proposal: set GUC variables for single query  (Jan Urbański <wulczer@wulczer.org>)
List pgsql-hackers
Tree view 
Jan Urbański <wulczer@wulczer.org> writes:
> this idea has cropped up last PGCon - the ability to set GUC variables
> for the duration of a single query. It would work by setting the GUCs
> for the duration of the query and setting them back to what they were
> after it has terminated.

Doesn't SET LOCAL cover this use-case pretty well already?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Jan Urbański
Date:
Subject: proposal: set GUC variables for single query
Next
From: Florian Pflug
Date:
Subject: Re: LIMITing number of results in a VIEW with global variables