Re: [GENERAL] ERROR: could not open relation with OID 49152

2008-07-21 Thread Scott Marlowe
On Mon, Jul 21, 2008 at 6:07 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Scott Marlowe" <[EMAIL PROTECTED]> writes: >> 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.r

Re: [GENERAL] ERROR: could not open relation with OID 49152

2008-07-21 Thread Alvaro Herrera
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

Re: [GENERAL] ERROR: could not open relation with OID 49152

2008-07-21 Thread Tom Lane
"Scott Marlowe" <[EMAIL PROTECTED]> writes: > 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), Pretty sure that should be c.oid. reg

[GENERAL] ERROR: could not open relation with OID 49152

2008-07-21 Thread Scott Marlowe
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