I agree.  It does remove all the triggers.  I also do it regularly.  More specifically, I generally use slonik commands to unsubscribe and remove slave nodes, and then I use the "drop schema" command to clean up the master node.

--S

-----Original Message-----
From: slony1-general-bounces at lists.slony.info [mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Martin Eriksson
Sent: Wednesday, August 20, 2008 2:47 AM
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] Dropped Master Cluster

Yes it will,

the cascade will remove ALL slony triggers.

I do it all the time..


René-Etienne Muscat wrote:
> But this will not remove the triggers from the tables! Is there a 
> clean way of getting this done or is this the only method?
>
> Thanks for your help,
> Rene
>
> On Wed, Aug 20, 2008 at 10:51 AM, Martin Eriksson 
> <m.eriksson at albourne.com <mailto:m.eriksson at albourne.com>> wrote:
>
>     on the slaves nodes issue:
>
>     drop schema <cluster name> cascade;
>
>     this will remove ALL slony stuff from the database it is run on.
>
>     /martin
>
>
>     René-Etienne Muscat wrote:
>
>         Hi everyone, I have dropped the master cluster from pgadmin
>         and cannot do the same to the slave cluster.
>         What can I do to remove this replication set from the slave
>         and get the tables back to normal?
>         P.S. I have other replication sets working fine, so I do not
>         want to do any changes that would affect the other replication
>         sets.
>          Rene
>         ------------------------------------------------------------------------
>
>         _______________________________________________
>         Slony1-general mailing list
>         Slony1-general at lists.slony.info
>         <mailto:Slony1-general at lists.slony.info>
>         http://lists.slony.info/mailman/listinfo/slony1-general
>          
>
>
>     _______________________________________________
>     Slony1-general mailing list
>     Slony1-general at lists.slony.info
>     <mailto:Slony1-general at lists.slony.info>
>     http://lists.slony.info/mailman/listinfo/slony1-general
>
>

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general