Re: Seems like bug in 9.1.3, need to confirm.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Seems like bug in 9.1.3, need to confirm.
Дата
Msg-id 25658.1387584767@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Seems like bug in 9.1.3, need to confirm.  (AI Rumman <rummandba@gmail.com>)
Список pgsql-general
AI Rumman <rummandba@gmail.com> writes:
> I executed the following query and got an error:
>  select relname, pg_size_pretty(pg_table_size(relname::text)) as s from
> pg_stat_user_tables order by pg_table_size(relname::text) desc  limit 10;
> ERROR:  relation "tab_20130206" does not exist

Use the OID, not the relname, else you'll have issues with any table
that's not in your search_path.

            regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: window function and order by
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade & tablespaces