On Tue, 5 Nov 2019 at 11:05, George Neuner <gneun...@comcast.net> wrote: > > On Sun, 03 Nov 2019 16:15:23 -0500, Tom Lane <t...@sss.pgh.pa.us> > >Why don't you just change the search path to empty before selecting? > > > I'm guessing this is fine inside a transaction, but what if you're > using a client that commits by statement? In that case, wouldn't the > change to the path affect the other backends?
See https://www.postgresql.org/docs/current/sql-set.html "SET only affects the value used by the current session." Also: "The effects of SET LOCAL last only till the end of the current transaction" Neither affects other sessions. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
