| 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) |