Re: [GENERAL] enabling join_collapse_limit for a single query only

2009-07-23 Thread Matt Harrison
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

Re: [GENERAL] enabling join_collapse_limit for a single query only

2009-07-23 Thread Albe Laurenz
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

[GENERAL] enabling join_collapse_limit for a single query only

2009-07-22 Thread groovefillet
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