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?
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20061104/262f7d24/attachment.bin