From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Christopher Browne <cbbrowne(at)ca(dot)afilias(dot)info> |
Cc: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Drop set problem - pgAdmin / Slony I |
Date: | 2008-01-18 16:09:15 |
Message-ID: | 20080118160915.GN7353@svr2.hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Fri, Jan 18, 2008 at 11:07:27AM -0500, Christopher Browne wrote:
> >> > > I've had this happen before. Removing the cluster and setting it
> >> > up
> >> > > again resolves the problem, however once we are in a production
> >> > > environment I can't go dropping the whole cluster and replicating
> >> > all
> >> > > the tables from scratch when it happens.
> >> >
> >> > Can you give us an exact step-by-step on how to make it happen?
> >> >
> >>
> >> I tried to subscribe a new set with a new table in it and for some
> >> reason it failed with the error mentioned. The slony logs show that
> >> slony was periodically trying to subscribe on the subscriber.
> >
> > I mean complete step-to-step, as in exactly what you click and enter. I've
> > done what is at least on the surface the same thing you have, with no
> > problems. So there must be somethign in the details.
> >
> >> Seeing as I couldn't remove it from pgAdmin, I went in and ran a
> >> slonik script to drop the set, however I didn't try to unsubscribe it
> >> with slonik first. So is there a chance it's come about from me not
> >> unsubscribing first?
> >
> > Part of it may - I don't recall offhand it the must-unsubscribe-first is a
> > rqeuirement of Slonik or just of pgAdmin.
>
> You don't need to unsubscribe first.
>
> The stored procedure dropSet() is perfectly happy to drop the set at
> any time. When the event propagates, it'll happily clear out all
> traces of the set.
Ok. Good. Then I think the reason it's not supported in pgAdmin is simply
because it made the GUI simpler to require that ;-)
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Field | 2008-01-21 16:57:25 | multiselect bug in edit grid on win32 |
Previous Message | Christopher Browne | 2008-01-18 16:07:27 | Re: Drop set problem - pgAdmin / Slony I |