Home > Archive > Slony1 PostgreSQL Replication > July 2005 > Re: ERROR: cache lookup failed for relation 438095645









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: ERROR: cache lookup failed for relation 438095645
Joe Markwardt

2005-07-07, 8:30 pm

On Thu, 2005-07-07 at 15:18 -0400, Jan Wieck wrote:
> On 7/7/2005 2:44 PM, Joe Markwardt wrote:
>
>
> after reading the entire thread it appears that you attempted to drop
> the table on the subscriber before the event for removing the table from
> the set actually propagated to the subscriber. That would be the only
> chance that the denyaccess trigger is still defined for it and the
> foreign key triggers are still "parked" on the tables PK index (that's
> one of the weird things Tom was talking about).
>

That could be I usually check the logs before I make any changes like
this to make sure my slonik commands have propogated, but I may have
forgotten this time. Any idea's on how to fix it other than re-starting
replication from scratch?

Thanks
Joe
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com