Re: enabling join_collapse_limit for a single query only - Mailing list pgsql-general

From Albe Laurenz
Subject Re: enabling join_collapse_limit for a single query only
Date
Msg-id D960CB61B694CF459DCFB4B0128514C203937E58@exadv11.host.magwien.gv.at
Whole thread Raw
In response to enabling join_collapse_limit for a single query only  (groovefillet@gmail.com)
Responses Re: enabling join_collapse_limit for a single query only
List pgsql-general
groovefillet wrote:
> Is it possible to set the runtime parameter 'join_collapse_limit' for
> a single query only without setting/unsetting it before/after?

Yes:

START TRANSACTION;

SET LOCAL join_collapse_limit = 42;

SELECT .....

COMMIT;

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: table.column in query results?
Next
From: Jasen Betts
Date:
Subject: Re: problem with pg_restore?