Thu May 18 09:04:30 PDT 2006
- Previous message: [Slony1-general] Can't remove dropped table from slony set--
- Next message: [Slony1-general] logtrigger not firing
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On May 18, 2006 08:36 am, Norman Yamada <nyamada at millburncorp.com> wrote: > Now we're stuck. I can't drop the table from the slony set, because > it complains that the table doesn't exist on the master node. I've re- > created the table on the master node to no avail. Worse, while my > slony set continues to function even without this table, I can't run > any other DDL scripts on the set -- it complains about the missing > table. This should work ... Assuming the replacement table you created is still there: Update sl_table.tab_reloid to the replacement table oid, and manually recreate the replication trigger on the table (paying attention to the name - see your other tables for examples), then you should be able to drop it from the set. -- Alan
- Previous message: [Slony1-general] Can't remove dropped table from slony set--
- Next message: [Slony1-general] logtrigger not firing
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list