Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx>
> To: slony1-general@xxxxxxxxxxxxxxxx
> Cc: pgsql-general@xxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxx
> http://lists.slony.info/mailman/listinfo/slony1-general
> 




      ___________________________________________________________ 
Yahoo! For Good helps you make a difference  

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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux