| PLPGSQL | bigint |
declare
p_set_id alias for $1;
p_set_comment alias for $2;
v_local_node_id int4;
begin
-- ----
-- Grab the central configuration lock
-- ----
lock table sl_config_lock;
v_local_node_id := getLocalNodeId('_schemadoc');
insert into sl_set
(set_id, set_origin, set_comment) values
(p_set_id, v_local_node_id, p_set_comment);
return createEvent('_schemadoc', 'STORE_SET',
p_set_id::text, v_local_node_id::text, p_set_comment::text);
end; |