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. -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de PostgreSQL _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
