Scott Marlowe escribió: > OK, I'm getting the above error on one of my fairly new 8.3 production > databases. It happens when I run a query to see the size of my > tables. > > SELECT pg_relation_size(c.relfilenode), n.nspname AS schemaname, > c.relname AS tablename, pg_get_userbyid(c.relowner) AS tableowner, > t.spcname AS tablespace, c.relhasindex AS hasindexes, c.relhasrules AS > hasrules, c.reltriggers > 0 AS hastriggers > FROM pg_class c > LEFT JOIN pg_namespace n ON n.oid = c.relnamespace > LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace > WHERE n.nspname = 'public'; > ERROR: could not open relation with OID 49152
Try pg_relation_size(c.oid) instead. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
