Hi Guys,
I was wondering if anyone could shed some light with type names returned by
pg_catalog.format_type sometimes having the schema name prepended, and
sometimes not? I'm calling it like format_type(pg_type.oid, NULL) .
I'm using pg9.0, but I remember seeing this years ago on older
Glyn Astill glynast...@yahoo.co.uk writes:
I was wondering if anyone could shed some light with type names returned by
pg_catalog.format_type sometimes having the schema name prepended, and
sometimes not? I'm calling it like format_type(pg_type.oid, NULL) .
General case: the schema name is
From: Tom Lane t...@sss.pgh.pa.us
To: Glyn Astill glynast...@yahoo.co.uk
Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org
Sent: Wednesday, 27 June 2012, 14:31
Subject: Re: [GENERAL] Type Name / Internal name returned by
pg_catalog.format_type
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