Glyn Astill <glynastill@xxxxxxxxxxx> writes: >> From: Tom Lane <tgl@xxxxxxxxxxxxx> >> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
