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 <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] > http://lists.slony.info/mailman/listinfo/slony1-general > ___________________________________________________________ Yahoo! For Good helps you make a difference http://uk.promotions.yahoo.com/forgood/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
