Cache lookup failed for relation message in PG 8.3.7

From: Keaton Adams <Keaton_Adams(at)McAfee(dot)com>
To: V S P <pgsql-general(at)postgresql(dot)org>
Subject: Cache lookup failed for relation message in PG 8.3.7
Date: 2010-02-08 21:10:13
Message-ID: C795CBC5.14D32%kadams@mxlogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Any ideas why we would be receiving this cache lookup failed message?

PostgreSQL 8.3.7 64 bit, RHEL 5 64 bit OS

Linux hostname.net 2.6.18-92.el5 #1 SMP Tue Apr 29 13:16:15 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux

<2010-02-07 08:05:36 MST>ERROR: cache lookup failed for relation 391262678
<2010-02-07 08:05:36 MST>STATEMENT: SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as "Type",
r.rolname as "Owner"
FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_roles r ON r.oid = c.relowner
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','')
AND n.nspname <> 'pg_catalog'
AND n.nspname !~ '^pg_toast'
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael van der Kolff 2010-02-08 21:23:49 WINDOW functions - proposed addition weight (dp) for percent_rank, cume_dist
Previous Message Oleg Bartunov 2010-02-08 20:01:45 Re: turning a tsvector without position in a weighted tsvector