Re: PostgreSQL 9.0b1 - Error when checking table sizes

On tor, 2010-05-27 at 22:41 +0100, Thom Brown wrote:
> This probably isn't a legitimate bug, but as a precaution....
>
> I'm running the following command against PostgreSQL 9.0 beta 1:
>
> psql -U postgres -d test -c "select tablename,
> pg_size_pretty(pg_table_size(tablename::regclass)) from pg_tables
> order by tablename;"
>
> And getting the following message:
>
> ERROR:  relation "sql_sizing" does not exist

This can be reduced to

select 'sql_sizing'::regclass;
ERROR:  relation "sql_sizing" does not exist

You need a schema qualification (it's in information_schema).