Hi, and thanks for the reply.
We're issuing queries from within our application where transactions
span a whole unit of work, so wrapping a single query in a transaction
just to set the param isn't really feasible except on a separate
connection, which i am loathe to do.
I was really hopi
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
--
Sent via pgsql-general maili
Hi there,
Is it possible to set the runtime parameter 'join_collapse_limit' for
a single query only without setting/unsetting it before/after?
Thanks,
matt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/ma