Re: [BUGS] PostgreSQL 9.0b1 - Error when checking table sizes

2010-05-27 Thread Stephen Frost
* Thom Brown (thombr...@gmail.com) wrote: > psql -U postgres -d test -c "select tablename, > pg_size_pretty(pg_table_size(tablename::regclass)) from pg_tables > where schemaname = 'public' order by tablename;" > > And this, for some reason, works... which is how I did it the other > day (hence why

Re: [BUGS] PostgreSQL 9.0b1 - Error when checking table sizes

2010-05-27 Thread Thom Brown
On 27 May 2010 23:00, Tom Lane wrote: > Thom Brown writes: >> 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))

Re: [BUGS] PostgreSQL 9.0b1 - Error when checking table sizes

2010-05-27 Thread Tom Lane
Thom Brown writes: > 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

Re: [BUGS] PostgreSQL 9.0b1 - Error when checking table sizes

2010-05-27 Thread Peter Eisentraut
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

[BUGS] PostgreSQL 9.0b1 - Error when checking table sizes

2010-05-27 Thread Thom Brown
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: