> >
> > 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

Reply via email to