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 _ at CLUSTERNAME@.updateRelname 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