PLPGSQL | integer |
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; |
Prev | Home | Next |
forwardconfirm(integer, integer, bigint, timestamp without time zone) | Up | getlocalnodeid(name) |