I am using slony to replicate some tables in a DB, but not all. When I try to
drop one of the non-replicated tables on the slave, I receive the following:
DROP TABLE summary_target ;
ERROR: "markets_pk" is an index
The summary_target table is not replicated, but the markets table is
replicated. The summary_target table has the following fkeys:
Foreign-key constraints:
"markets_summary_target_fk" FOREIGN KEY (market_id) REFERENCES
markets(market_id) ON UPDATE CASCADE ON DELETE CASCADE
"occasions_summary_target_fk" FOREIGN KEY (occasion_id) REFERENCES
occasions(occasion_id) ON UPDATE CASCADE ON DELETE CASCADE
"questions_summary_target_fk" FOREIGN KEY (question_id) REFERENCES
questions(question_id) ON UPDATE CASCADE ON DELETE CASCADE
"targets_summary_target_fk" FOREIGN KEY (target_id) REFERENCES
targets(target_id) ON UPDATE CASCADE ON DELETE CASCADE
"types_summary_target_fk" FOREIGN KEY (type_id) REFERENCES types(type_id)
ON UPDATE CASCADE ON DELETE CASCADE
mps=# begin;
BEGIN
mps=# drop trigger _mpscluster_denyaccess_29 ON markets;
DROP TRIGGER
mps=# ALTER TABLE summary_target DROP CONSTRAINT markets_summary_target_fk;
ERROR: "markets_pk" is an index
I grepped through the source and it looks like this is a problem with a grant.
So I thought maybe it's a problem with the foreign key that relates to the
markets table, since the markets table is replicated and has a no access
trigger on it...so I tried deleting it.
drop trigger _mpscluster_denyaccess_29 ON markets;
DROP TRIGGER
DROP TABLE summary_target ;
ERROR: "markets_pk" is an index
Still the same problem. Also the same problem if I attempt to drop any of the
foreign key constraints on summary_target:
drop trigger _mpscluster_denyaccess_29 ON markets;
DROP TRIGGER
ALTER TABLE summary_target DROP CONSTRAINT markets_summary_target_fk; ERROR:
"markets_pk" is an index
Suggestions as to what I can do to remove this non subscribed table from the
slave?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
