Christopher B. Browne's Home Page
cbbrowne@gmail.com

1.65. generate_sync_event( interval )

Function Properties

PLPGSQLinteger
Generate a sync event if there has not been one in the requested interval.
    declare
    	p_interval     alias for $1;
    	v_node_row     record;
    
    BEGIN
    	select 1 into v_node_row from sl_event 
           	  where ev_type = 'SYNC' and ev_origin = getLocalNodeId('schemadoc')
              and ev_timestamp > now() - p_interval limit 1;
    	if not found then
    		-- If there has been no SYNC in the last interval, then push one
    		perform createEvent('schemadoc', 'SYNC', NULL);
    		return 1;
    	else
    		return 0;
    	end if;
    end;

Google

If this was useful, let others know by an Affero rating

Contact me at cbbrowne@gmail.com