Hi chaps,
I know there's been a bit of "activity" on this listrecently - but does anyone know where I should start looking to
resolvethebelow?
----- Original Message ----
> From: Glyn Astill <glynastill@yahoo.co.uk>
> To: slony1-general@lists.slony.info
> Cc: pgsql-general@postgresql.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@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
___________________________________________________________
Yahoo! For Good helps you make a difference
http://uk.promotions.yahoo.com/forgood/