Re: 8.3.7, 'cache lookup failed' for a table

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 8.3.7, 'cache lookup failed' for a table
Date: 2010-05-11 14:19:22
Message-ID: AANLkTilY0JXGyugYEcpBp4EAjoHDWG7cowitvgh39llT@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Having seen that all previous problems went unresolved, heres a bit
more info. The system is 32 bit, running on enterprise redhat 4.7. It
is slony's slave node, so it will be hit with quite few updates.
My guess is that it happened when we ere adding/removing slony to the
system for Nth time (due to it sometimes going out of sync).
Another thing that makes me think so, is what I've seen in pg_dump's output:

CREATE TRIGGER _simreplic_denyaccess_208
BEFORE INSERT OR DELETE OR UPDATE ON some_table
FOR EACH ROW
EXECUTE PROCEDURE 28799('_somereplic');

Which is obviously wrong.

hth.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2010-05-11 14:23:18 Re: List traffic
Previous Message Tom Lane 2010-05-11 14:16:47 Re: can function arguments have the type tablename.columnname%TYPE?