On Thu, Jan 04, 2007 at 05:16:10PM -0500, Andrew Sullivan wrote:
> Not just dropping them, but the following appears to work:

Oops, not quite.

> Call it _n_.  Then you do this:
> 
> 1.	On the origin, do
> 
> 	SELECT _slonyschema.altertablerestore(_n_);
> 
> 2.	Wait.  Make sure the events propogate everywhere.
> 
> 5.	On the origin, do
> 
> 	SELECT _slonyschema.altertableforreplication(_n_);

You actually don't need step 2, but you _do_ need to do steps 1 and 5
on every node.  Now that I think about it, I knew that, but forgot. 
Anyway, I think I'll write up a little script that will do this
generically, on the presumption that others might need it.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
		--H.W. Fowler