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).