Glen Eustace geustace
Tue Apr 4 13:30:17 PDT 2006
> This is odd. Can it be that the table has been dropped and recreated, 
> and thereby it's OID changed? If the tables OID in pg_class is different 
> from the tab_reloid in sl_table (9527801), that would explain the error.

Thank you, that is exactly what happened.  About 4 months ago, I had to
make a varchar field longer and did so by using pg_dump.  I had
forgotten all about it.  It seemed such a trivial change at the time.

> There is an (undocumented?) slonik command
> 
>    REPAIR CONFIG
>      (set id = <int>[, event node = <int>] [, execute only on = <int>]);
> 
> Which should take care of this problem.

I'll give this a go.

Bingo.

Thanks heaps, worked like a charm !!

Glen.





More information about the Slony1-general mailing list