On Sun, 03 Nov 2019 16:15:23 -0500, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >Michael Shapiro <mshapiro51@xxxxxxxxx> writes: >> It seems that the definition of a view from pg_catalog.pg_views does not >> qualify the tables used in the view if the tables are in the current search >> path. > >> Is it possible to either have the definition always qualify all tables >> independent of the search_path (or else provide a new column that does >> that)? > >Why don't you just change the search path to empty before selecting? > > regards, tom lane 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? George
