so should _slony.sl_table.tab_reloid match
pg_catalog.pg_class.relfilenode for each table in a replication set? 

-----Original Message-----
From: slony1-general-bounces at lists.slony.info
[mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Andrew
Sullivan
Sent: Thursday, October 02, 2008 10:35 AM
To: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] sanity check for all tables in a set

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
ajs at commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/
_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general