Re: 8.3.7, 'cache lookup failed' for a table - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: 8.3.7, 'cache lookup failed' for a table
Date
Msg-id AANLkTilY0JXGyugYEcpBp4EAjoHDWG7cowitvgh39llT@mail.gmail.com
Whole thread Raw
In response to 8.3.7, 'cache lookup failed' for a table  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: 8.3.7, 'cache lookup failed' for a table  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Re: 8.3.7, 'cache lookup failed' for a table  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List 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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: can function arguments have the type tablename.columnname%TYPE?
Next
From: Jerry LeVan
Date:
Subject: Re: Subscription Mess...