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). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
