Re: ERROR: could not open relation with OID 49152

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