On 11/8/13 2:21 PM, Tom Lane wrote:
Jim Nasby <jna...@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.
Yeah, that's what I did in this case. I'm just trying to make it more obvious
to users that make this mistake.
Is anyone opposed to some kind of hint?
--
Jim Nasby, Lead Data Architect (512) 569-9461
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
