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/