registernodeconnection( integer )

1.85. registernodeconnection( integer )

Function Properties

Language: PLPGSQL

Return Type: integer

Register (uniquely) the node connection so that only one slon can service the node

declare
	p_nodeid	alias for $1;
begin
	insert into sl_nodelock
		(nl_nodeid, nl_backendpid)
		values
		(p_nodeid, pg_backend_pid());

	return 0;
end;