On Tue 14 Dec 2004, Darcy Buskermolen wrote:
> On December 14, 2004 05:00 am, Paul Slootman wrote:

> > I just did a drop table of one table (it's not needed anymore by the
> > application which uses the database), and then realised that perhaps I
> > should have done a "set drop table" first. That doesn't work now, it
> > says: "Slony-I: Table with id 1 not found".
> >
> > - Is there a way around this?
> 
> No, currently there is not a nice way around this.  To fix this you'll have to 
> manualy delete rows from the _CLUSTER.* tables; most notably sl_table , 
> sl_log_1 , sl_log_2  on all the nodes.

OK, I'll have a try

> > - Is there a way to list what tables have what IDs? I happened to know
> >   that this table was added with ID 1, but I wonder how to find it out
> >   if you don't know this...
> 
> No you can't not after it has been dropped.  If you want to find out the real 
> relation name of a object you havn't yet deleted youcan use the following:
> 
> SELECT slt.tab_id, pgc.relname FROM pg_class pgc, "_cluster".sl_table slt 
> WHERE pgc.oid = slt.reloid ......

Ah, replace reloid with tab_reloid and then this works fine :-)

Thanks!
Paul Slootman