Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

rootpgsqlshareextensionpgrowlocks--1.0--1.1.sql

pgrowlocks--1.0--1.1.sql18 linesDownload Raw Back to extension

1/* contrib/pgrowlocks/pgrowlocks--1.0--1.1.sql */2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION4\echo Use "ALTER EXTENSION pgrowlocks UPDATE TO '1.1'" to load this file. \quit5 6ALTER EXTENSION pgrowlocks DROP FUNCTION pgrowlocks(text);7DROP FUNCTION pgrowlocks(text);8CREATE FUNCTION pgrowlocks(IN relname text,9    OUT locked_row TID,		-- row TID10    OUT locker XID,		-- locking XID11    OUT multi bool,		-- multi XID?12    OUT xids xid[],		-- multi XIDs13    OUT modes text[],		-- multi XID statuses14    OUT pids INTEGER[])		-- locker's process id15RETURNS SETOF record16AS 'MODULE_PATHNAME', 'pgrowlocks'17LANGUAGE C STRICT;18