Jayadevan M <maymala.jayade...@gmail.com> writes:
> I thought current_schemas and search_path will return the same set of
> schemas (except that current_schema will show pg_catalog also, if we use
> true). Shouldn't mynewschema appear in the output of select
> current_schemas(true)?
Only if it actually exists (and you have usage privilege on it). See
the description of the search_path variable: nonexistent entries are
silently ignored.
Possibly this behavior should be documented under current_schemas()
as well as under the GUC variable.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
