casting behavior of oids and relation names

Поиск
Список
Период
Сортировка
От salah jubeh
Тема casting behavior of oids and relation names
Дата
Msg-id 1337174456.52834.YahooMailNeo@web161502.mail.bf1.yahoo.com
обсуждение исходный текст
Ответы Re: casting behavior of oids and relation names  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: casting behavior of oids and relation names  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
Список pgsql-general
Hello guys,

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 ? 

Thanks in advance

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: vacuum, vacuum full and problems releasing disk space
Следующее
От: Tom Lane
Дата:
Сообщение: Re: casting behavior of oids and relation names