Christopher B. Browne's Home Page
cbbrowne@acm.org

8.129. unsubscribeset_int(integer, integer)

Function Properties

PLPGSQLinteger
unsubscribeSet_int (sub_set, sub_receiver) All the REAL work of removing the subscriber is done before the event is generated, so this function just has to drop the references to the subscription in sl_subscribe.
    declare
    	p_sub_set			alias for $1;
    	p_sub_receiver		alias for $2;
    begin
    	-- ----
    	-- Grab the central configuration lock
    	-- ----
    	lock table sl_config_lock;
    
    	-- ----
    	-- All the real work is done before event generation on the
    	-- subscriber.
    	-- ----
    	delete from sl_subscribe
    			where sub_set = p_sub_set
    				and sub_receiver = p_sub_receiver;
    
    	-- Rewrite sl_listen table
    	perform RebuildListenEntries();
    
    	return p_sub_set;
    end;

Google
Contact me at cbbrowne@acm.org