contrib/pgrowlocks/pgrowlocks.sql.in

   1 /* $PostgreSQL$ */
   2
   3 -- Adjust this setting to control where the objects get created.
   4 SET search_path = public;
   5
   6 CREATE OR REPLACE FUNCTION pgrowlocks(IN relname text,
   7     OUT locked_row TID,         -- row TID
   8     OUT lock_type TEXT,         -- lock type
   9     OUT locker XID,             -- locking XID
  10     OUT multi bool,             -- multi XID?
  11     OUT xids xid[],             -- multi XIDs
  12     OUT pids INTEGER[])         -- locker's process id
  13 RETURNS SETOF record
  14 AS 'MODULE_PATHNAME', 'pgrowlocks'
  15 LANGUAGE C STRICT;