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 |
Subject: | Re: [Slony1-general] ERROR: XX000: cache lookup failed for relation |
Date: | 2008-04-05 11:47:08 |
Message-ID: | 860349.6752.qm@web25803.mail.ukl.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Volkan YAZICI | 2008-04-05 11:47:25 | Re: default value based on select |
Previous Message | Martijn van Oosterhout | 2008-04-05 11:41:20 | Re: modules |