Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes15kdownloads

rootpgsqlshareextensionpgrowlocks--1.2.sql

pgrowlocks--1.2.sql16 linesDownload Raw Back to extension

1/* contrib/pgrowlocks/pgrowlocks--1.2.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION pgrowlocks" to load this file. \quit5 6CREATE FUNCTION pgrowlocks(IN relname text,7    OUT locked_row TID,		-- row TID8    OUT locker XID,		-- locking XID9    OUT multi bool,		-- multi XID?10    OUT xids xid[],		-- multi XIDs11    OUT modes text[],		-- multi XID statuses12    OUT pids INTEGER[])		-- locker's process id13RETURNS SETOF record14AS 'MODULE_PATHNAME', 'pgrowlocks'15LANGUAGE C STRICT PARALLEL SAFE;16