Glyn Astill <glynastill@yahoo.co.uk> writes:
>> From: Tom Lane <tgl@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
thesame 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