Re: PostgreSQL 9.0b1 - Error when checking table sizes

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Thom Brown <thombrown(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0b1 - Error when checking table sizes
Date: 2010-05-27 21:53:12
Message-ID: 1274997192.18581.44.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-05-27 22:00:00 Re: PostgreSQL 9.0b1 - Error when checking table sizes
Previous Message Thom Brown 2010-05-27 21:41:02 PostgreSQL 9.0b1 - Error when checking table sizes