aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_lock_registration
Parameters
Name
Type
Mode
lock_user
text
IN
session_id
text
IN
register_id
integer
IN
Definition
declare lock_id bigint; is_locked boolean; begin delete from record_lock lck where (lck.register_id is not distinct from $3) and (lck.booking_item is null) and (lck.block_id is null) and (lck.booking_id is null); insert into record_lock(lock_type, lock_user, session_id, register_id) values ('registration', $1, $2, $3) returning id into lock_id; -- perform sp_log_debug('sp_lock_registration', -- jsonb_pretty(jsonb_build_object( -- 'lock_id', lock_id, -- 'lock_user', $1, -- 'register_id', $3, -- 'session_id', $2, -- 'lock_time', current_timestamp -- )), -- true); return lock_id; end