pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Fuzzygoth <dav.phillips@ntlworld.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Can't drop tables ERROR: cache lookup failed for relation 411727
Date: Thu, 24 May 2007 11:32:49 -0400
Message-ID: <5127.1180020769@sss.pgh.pa.us> (raw)
In-Reply-To: <1179999835.896527.229070@u30g2000hsc.googlegroups.com>
References: <1179999835.896527.229070@u30g2000hsc.googlegroups.com>

Fuzzygoth <dav.phillips@ntlworld.com> writes:
> I have been attempting to move our database to our new database server
> but i have encountered a few problems along the way. One of the errors
> that I encountered was the error below when trying to drop a table so
> I could re-build it.

> ERROR:  cache lookup failed for relation 411727

If this database has been a slony slave in the past, then this could
indeed be slony's fault.  You'd get better answers about that (and about
how to deal with it) on the slony mail lists --- see
http://lists.slony.info/mailman/listinfo

			regards, tom lane



view thread (2+ messages)

Message-ID: <5127.1180020769@sss.pgh.pa.us>
Permalink:  ../5127.1180020769@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/5127.1180020769@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, dav.phillips@ntlworld.com
  Subject: Re: Can't drop tables ERROR: cache lookup failed for relation 411727
  In-Reply-To: <5127.1180020769@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox