Slony-I REL_1_1_0 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Chapter 1. Schema schemadoc | Fast Forward | Next |
Function Properties
Language: PLPGSQL
Return Type: integer
ddlScript_int(set_id, script, only_on_node) Processes the DDL_SCRIPT event. On slave nodes, this restores original triggers/rules, runs the script, and then puts tables back into replicated mode.declare p_set_id alias for $1; p_script alias for $2; p_only_on_node alias for $3; v_set_origin int4; v_no_id int4; v_row record; begin -- ---- -- Grab the central configuration lock -- ---- lock table sl_config_lock; -- ---- -- Check that we either are the set origin or a current -- subscriber of the set. -- ---- v_no_id := getLocalNodeId('_schemadoc'); select set_origin into v_set_origin from sl_set where set_id = p_set_id for update; if not found then raise exception 'Slony-I: set % not found', p_set_id; end if; if v_set_origin <> v_no_id and not exists (select 1 from sl_subscribe where sub_set = p_set_id and sub_receiver = v_no_id) then return 0; end if; -- ---- -- If execution on only one node is requested, check that -- we are that node. -- ---- if p_only_on_node > 0 and p_only_on_node <> v_no_id then return 0; end if; -- ---- -- Restore all original triggers and rules -- ---- for v_row in select * from sl_table where tab_set = p_set_id loop perform alterTableRestore(v_row.tab_id); end loop; -- ---- -- Run the script -- ---- execute p_script; -- ---- -- Put all tables back into replicated mode -- ---- for v_row in select * from sl_table where tab_set = p_set_id loop perform alterTableForReplication(v_row.tab_id); end loop; return p_set_id; end;