Andreas,

The node is definitely still subscribed, and I'd like to keep it that way. 
The particular table I want to drop is not part of the subscription set.


On Sat, 4 Nov 2006, Andreas Kostyrka wrote:

> Well, the simplest thing is to use EXECUTE SCRIPT that runs only on that
> one node. As it runs only on the slave, problems with getting the locks
> seems to be way easier to get then on master.
>
> Just make sure that it's really not subscribed anymore.
>
> Andreas
>
> Am Freitag, den 03.11.2006, 17:21 -0800 schrieb Jeff Frost:
>> 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