Glyn Astill <glynast...@yahoo.co.uk> writes:
>> From: Tom Lane <t...@sss.pgh.pa.us>
>> General case: the schema name is used if the type wouldn't be found
>> without it, according to your current search_path.
> However none of that explains why one of the types is returned with the
> schema name and the other is not, both are in the same schema which is in the
> current search_path.
It's difficult to comment on that without a concrete example, but
"visible according to search_path" does not only mean "in a schema
that's in search_path". It also requires "not masked by a similarly
named object appearing earlier in the path".
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
