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 	<jeff at frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954