Jaime Casanova jaime at 2ndquadrant.com
Sat Jul 31 00:09:45 PDT 2010
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


More information about the Slony1-general mailing list