salah jubeh <s_jubeh@xxxxxxxxx> writes:
> In some cases when I cast the oid to relation names ('xxxx'::regclass::text) I get schemaname.tablename and in some cases I just get tablename. I thought at the beginning, this is due name duplication of tables in different schemas but it seems not. Also, this seems as a schema option because it happen only in certain schemas. How I can get a consistent names of the casting ?
That's a feature, not a bug --- it doesn't qualify the name if
qualification is unnecessary given your current search_path.
For user tables, you could force it to always qualify by setting
search_path to empty, I think.
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
