Postgres Pro
Downloads
Home   >   mailing lists

Re: regclass error reports improperly downcased - Mailing list pgsql-hackers

From Tom Lane
Subject Re: regclass error reports improperly downcased
Date
Msg-id 24972.1383942089@sss.pgh.pa.us
Whole thread Raw
In response to Re: regclass error reports improperly downcased  (Jim Nasby <jnasby@enova.com>)
Responses Re: regclass error reports improperly downcased  (Jim Nasby <jnasby@enova.com>)
List pgsql-hackers
Tree view 
Jim Nasby <jnasby@enova.com> writes:
> Ahh, duh. Hrm... I ran across this because someone here got confused by this:

> SELECT pg_total_relation_size( schema_name || '.' || relname ) FROM pg_stat_all_tables
> ERROR: relation "moo" does not exist

Personally I'd do that like
   select pg_total_relation_size(oid) from pg_class where ...

and avoid fooling with regclass conversion at all.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: backup.sgml-cmd-v003.patch
Next
From: Heikki Linnakangas
Date:
Subject: Re: Gin page deletion bug