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

On Wed, May 12, 2010 at 11:09 AM, Alban Hertroys
<dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> wrote:
> On 12 May 2010, at 12:01, Glyn Astill wrote:
>
>> Did you not mention that this server was a slony slave at some point though?
>>
>> Just because you have removed slony, and the error comes from postgresql itself does not mean the corruption was not caused by misuse of slony.
>
> Indeed. I wonder if "when we ere adding/removing slony to the system for Nth time (due to it sometimes going out of sync)" may be caused by that as well.
>

ok, so either upgrade to newer version of slony, or drop all tables,
and recreate them every time slony is removed and readded to the
database.

And I guess the only reason postgresql doesn't like it, is due to
slony's behavior.

thanks guys.

--
GJ