salah jubeh <s_ju...@yahoo.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
