## 1.32. ddlscript_int( integer, text, integer )

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;