↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Information Functions And Operators

pg_get_multixact_members

Read the PG 18 manual

Returns the transaction ID and lock mode for each member of the specified multixact ID.

Reading PG 18current·documented in 8 of 27 versions, 13 to 20

Signatures & examples

pg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )
Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes forupd, fornokeyupd, sh, and keysh correspond to the row-level locks FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE, and FOR KEY SHARE, respectively, as described in Section 13.3.2. Two additional modes are specific to multixacts: nokeyupd, used by updates that do not modify key columns, and upd, used by updates or deletes that modify key columns.
Version history 1
  1. 12 → 13 added

Definition snapshot: b7bd9cda · English manual source