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.co.uk>
> To: slony1-general at lists.slony.info
> Cc: pgsql-general at 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 at 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/