maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_getnextdevmessageid(integer)
Parameters
Name
Type
Mode
iddevice
integer
IN
Definition
/* v20150420 RRB To generate unique message identifiers on a device basis, implemented using sequences as RRB decided it is the best way to deal with high concurrency */ DECLARE seq_name varchar; BEGIN SET search_path = seq_devmessageid, public; seq_name := 'devmessageid_'|| iddevice::varchar; IF NOT EXISTS (SELECT 1 FROM pg_class c JOIN pg_namespace n ON c.relnamespace = n.oid WHERE relname = seq_name AND relkind = 'S' AND nspname = 'seq_devmessageid') THEN EXECUTE 'CREATE SEQUENCE '||seq_name||' MAXVALUE 65535 cache 100 cycle'; END IF; RETURN nextval(seq_name); END