> > > > > postgres_fdw resets the search path to pg_catalog while opening > connection > > to the server. The reason behind this is explained in deparse.c > > > > * We assume that the remote session's search_path is exactly > "pg_catalog", > > * and thus we need schema-qualify all and only names outside pg_catalog. > > Hmm. OK, should we revert the schema-qualification part of that > commit, or just leave it alone? > > If we leave that code as is, someone who wants to add similar code later would get confused or will be tempted to create more instances of schema-qualification. I think we should revert the schema qualification.
-- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company