• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• ibmutl001_unlock_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_unlock_transaction.sql Maven / Gradle / Ivy

-- Function: public.ibmutl001_unlock_transaction()

-- DROP FUNCTION public.ibmutl001_unlock_transaction();

CREATE OR REPLACE FUNCTION ibmutl001_unlock_transaction()
  RETURNS void AS
$BODY$
DECLARE

  aSID text;

BEGIN
  select to_char(pg_backend_pid(), '999999999') into aSID;
  delete from TRANSLOCK where
     sid = aSID;
END;


$BODY$
  LANGUAGE plpgsql VOLATILE SECURITY DEFINER
  COST 100;