Re: [Slony1-general] ERROR: XX000: cache lookup failed for relation

Hi chaps,

I know there's been a bit of "activity" on this listrecently - but does anyone know where I should start looking to resolvethe below?

----- Original Message ----
> From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
> To: slony1-general(at)lists(dot)slony(dot)info
> Cc: pgsql-general(at)postgresql(dot)org
> Sent: Friday, 4 April, 2008 3:05:18 PM
> Subject: [Slony1-general] ERROR: XX000: cache lookup failed for relation
>
> Hi chaps,
>
> I've got a problem trying to drop a table, I get the error "cache lookup failed
> for relation"
>
> SEE=# drop table replicated_users;
> ERROR: XX000: cache lookup failed for relation 30554884
> LOCATION: getRelationDescription, dependency.c:2021
> Now this table is on a slony-I slave and was in replication when I tried to drop
> it - I presume this is a big mistake and I should never try to drop a table
> without first droping it from replication?
>
> In addition I'd set up a trigger on the table "replicate_users".
>
> If I do:
>
> select relname,oid from pg_class where relname = 'replicated_users';
>
> -[ RECORD 1 ]-------------
> relname | replicated_users
> oid | 30554879
>
> Thats not the same oid as the one it's complaining about.
>
> Does anyone have any idea why this has happened or how I can fix it?
>
> Cheers
> Glyn
>
>
>
>
>
>
> ___________________________________________________________
> Yahoo! For Good helps you make a difference
>
> http://uk.promotions.yahoo.com/forgood/
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general(at)lists(dot)slony(dot)info
> http://lists.slony.info/mailman/listinfo/slony1-general
>

___________________________________________________________
Yahoo! For Good helps you make a difference

http://uk.promotions.yahoo.com/forgood/