On 9/20/2004 2:01 PM, elein wrote:
> As I understand it, you will have triggers and/or rules
> on your base tables remaining.  I have not verified
> this.  Jan told me this, but did not specify whether
> the triggers were on base tables or not.  I assume
> they are.

The other way around ... on the subscribers (slaves), the subscribed 
tables have their triggers and rules parked on their PK index OID ... 
which is ugly and eggebeh and pfui, but it's the way it is for now. So 
simply dropping the replication schema will leave the slave database in 
an inconsistent state.


Jan

> 
> --elein
> 
> On Mon, Sep 20, 2004 at 09:41:43AM -0600, Ed L. wrote:
>> On Friday September 17 2004 12:26, elein wrote:
>> > It is suggested that you use uninstall node rather
>> > than dropping the schema.  Otherwise you will leave
>> > triggers and stuff hanging around.
>> 
>> Good to know "uninstall node" is an option.  Using "drop schema xxxx 
>> cascade" does appear to drop everything, including all triggers, at least 
>> in 8.0, AFAICS.  Am I missing something?
>> 
>> Ed
>> 
>> 
>> >
>> > --elein
>> >
>> > On Fri, Sep 17, 2004 at 11:19:46AM -0600, Ed L. wrote:
>> > > On Friday September 17 2004 10:58, Ed L. wrote:
>> > > > Also, do you have a script which will completely strip replication
>> > > > from the DB?
>> > >
>> > > I guess dropping the replication schema will do it?  (Not counting any
>> > > pkey columns added to the user's schema by slonik, of course.)  Does
>> > > that drop everything?
>> > >
>> > > Ed
>> > >
>> > > _______________________________________________
>> > > Slony1-general mailing list
>> > > Slony1-general at gborg.postgresql.org
>> > > http://gborg.postgresql.org/mailman/listinfo/slony1-general
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #