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/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
