• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• ibmutl001_lock_transaction.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

postgresql.function.ibmutl001_lock_transaction.sql Maven / Gradle / Ivy

-- Function: public.ibmutl001_lock_transaction()

-- DROP FUNCTION public.ibmutl001_lock_transaction();

CREATE OR REPLACE FUNCTION ibmutl001_lock_transaction()
  RETURNS void AS
$BODY$
DECLARE
  aSID text;
BEGIN
  select to_char(pg_backend_pid(), '999999999') into aSID;
  insert into TRANSLOCK(SID,STATUS) VALUES (aSID,0);
END;


$BODY$
  LANGUAGE plpgsql VOLATILE SECURITY DEFINER
  COST 100;