On 4/5/2008 7:47 AM, Glyn Astill wrote:
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?
Yes, a "SET DROP TABLE" is mandatory prior to dropping the table itself.
This is because up to version 1.2.x, Slony is deliberately corrupting
the system catalog on subscriber nodes in order to suppress triggers and
rules to fire (this can only be controlled by other means since Postgres
8.3 and will be done so in Slony 2.0).
Jan
----- 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/
_______________________________________________
Slony1-general mailing list
Slony1-general@xxxxxxxxxxxxxxxx
http://lists.slony.info/mailman/listinfo/slony1-general
--
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin
