Skip site navigation (1) Skip section navigation (2)

PostgreSQL 9.0b1 - Error when checking table sizes

From: Thom Brown <thombrown(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: PostgreSQL 9.0b1 - Error when checking table sizes
Date: 2010-05-27 21:41:02
Message-ID: AANLkTilG8_aZvqKFsQDQzX7No8KN3JdEdVF1fGtEjB3A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

It doesn't matter which database name I use.  It doesn't have a
problem getting database sizes though.  This is under Gentoo Linux x64
with 2.6.32 kernel.

I'm certain I've successfully listed table sizes in the database a
couple days ago.

Thanks

Thom

Responses

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2010-05-27 21:53:12
Subject: Re: PostgreSQL 9.0b1 - Error when checking table sizes
Previous:From: Tom LaneDate: 2010-05-27 16:41:28
Subject: Re: Query causing explosion of temp space with join involving partitioning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group