Tue Apr 4 13:30:17 PDT 2006
- Previous message: [Slony1-general] Manually removing slony
- Next message: [Slony1-general] Manually removing slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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.
- Previous message: [Slony1-general] Manually removing slony
- Next message: [Slony1-general] Manually removing slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list