On Tue, Sep 30, 2008 at 02:27:08PM -0500, Mark Keisler wrote: > Someone deleted that table at some point and now I can't move the set > and I can't unsubscribe the set. It didn't seem like I could do > anything at this point besides manually strip out the cluster schema and > start over. So my first question is if there are any other options at > this point?
I don't think so. Re-educate your users not to drop things out from under you. No DDL! > Secondly, is there some sort of check that I can run periodically to > make sure a set is still intact so something like this doesn't bite me > right when I need to move a set? You can check the _slony.sl_tables and _slony.sl_sequence tables. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
