Jaime Casanova wrote: > Hi, > > I want to move some replicated tables to a new schema, so i execute > "ALTER TABLE SET SCHEMA new_schema" via the SLONIK EXECUTE SCRIPT > command and the result was: > - on origin: everything is ok, table moved and sl_table fixed > - on subscriber: table was moved but sl_table still says that the > table is in public (i guess i can update sl_table manually but i > prefer it happens automagically) > > this was on pg 8.4 with slony 1.2.20 > > I also tried to rename the schema via the SLONIK EXECUTE SCRIPT > command and on subscriber the schema wasn't renamed.
I think this is a bug. The function _...@[email protected] adjustst the sl_table to reflect the name in the catalog. It is being called by ddlScript_complete() which only runs on the event node of an execute script. I think we really want to call this function from ddlScript_complete_int() that gets called on both nodes. You could call updateRelname directly but I don't see how that is any better than doing the update yourself. -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
