> Glyn Astill writes:
> > AFAIK you cannot dump out, then restore a schema with slony in place.
> >
> > Slony uses object OIDs (as you've seen in alterTableRestore()) and even with 
> the -o flag you cannot dump them, you can only dump the OIDs for row data, thus 
> when you reload all your data the slony schema is junk.
> >
> > The only way to do it is to drop cascade the slony schema and setup the slony 
> cluster again by starting from scratch or adding it as a new node to an existing 
> cluster.
> >
> > Put me straight if I'm wrong here people.
> >
> From: chris <cbbrowne at ca.afilias.info>
> 
> There is a Slonik command intended to do this sort of repair...
>   

Wow, makes me wonder how I missed that before!!



      __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html