On Tue, 5 Nov 2019 at 11:05, George Neuner <gneuner2@xxxxxxxxxxx> wrote: > > On Sun, 03 Nov 2019 16:15:23 -0500, Tom Lane <tgl@xxxxxxxxxxxxx> > >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
