maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_update_seqalertconf()
Parameters
Name
Type
Mode
Definition
DECLARE max_idalertconf bigint := 0 ; seq_name varchar := 'sec_alertconf'; BEGIN SELECT INTO max_idalertconf coalesce(max(idalertconf),0) FROM alertconf; max_idalertconf := max_idalertconf + 1; EXECUTE 'ALTER SEQUENCE '|| seq_name ||' RESTART WITH '|| max_idalertconf; RETURN max_idalertconf; END;