Show
Ignore:
Timestamp:
10/18/09 02:15:30 (5 years ago)
Author:
Theo Schlossnagle <jesus@omniti.com>
git-committer:
Theo Schlossnagle <jesus@omniti.com> 1255832130 +0000
git-parent:

[4bd41daf5972011000e2f08b921a9809998bd036]

git-author:
Theo Schlossnagle <jesus@omniti.com> 1255832130 +0000
Message:

fix these up to take th noit through

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/sprocs/stratcon.get_storage_node_for_sid.sql

    r003566b rb2014c0  
    1 CREATE OR REPLACE FUNCTION stratcon.choose_storage_node_for_sid(out o_storage_node_id int, out o_dsn text)  
     1CREATE OR REPLACE FUNCTION stratcon.choose_storage_node_for_sid(in v_noit text, out o_storage_node_id int, out o_fqdn text, out o_dsn text)  
    22RETURNS RECORD  
    33AS $$ 
    44BEGIN 
    5     SELECT storage_node_id, dsn from stratcon.storage_node order by random() limit 1 INTO o_storage_node_id, o_dsn;  
     5    -- we could be smart with v_noit 
     6    SELECT storage_node_id, fqdn, dsn from stratcon.storage_node order by random() limit 1 INTO o_storage_node_id, o_dsn;  
    67END 
    78$$ LANGUAGE plpgsql  
     
    910;  
    1011 
    11 GRANT EXECUTE ON FUNCTION stratcon.choose_storage_node_for_sid() TO stratcon; 
     12GRANT EXECUTE ON FUNCTION stratcon.choose_storage_node_for_sid(text) TO stratcon;