@@ -25540,6 +25540,31 @@ SELECT collation for ('foo' COLLATE "de_DE");
25540
25540
details.
25541
25541
</para></entry>
25542
25542
</row>
25543
+
25544
+ <row>
25545
+ <entry role="func_table_entry"><para role="func_signature">
25546
+ <indexterm>
25547
+ <primary>pg_get_multixact_members</primary>
25548
+ </indexterm>
25549
+ <function>pg_get_multixact_members</function> ( <parameter>multixid</parameter> <type>xid</type> )
25550
+ <returnvalue>setof record</returnvalue>
25551
+ ( <parameter>xid</parameter> <type>xid</type>,
25552
+ <parameter>mode</parameter> <type>text</type> )
25553
+ </para>
25554
+ <para>
25555
+ Returns the transaction ID and lock mode for each member of the
25556
+ specified multixact ID. The lock modes <literal>forupd</literal>,
25557
+ <literal>fornokeyupd</literal>, <literal>sh</literal>, and
25558
+ <literal>keysh</literal> correspond to the row-level locks
25559
+ <literal>FOR UPDATE</literal>, <literal>FOR NO KEY UPDATE</literal>,
25560
+ <literal>FOR SHARE</literal>, and <literal>FOR KEY SHARE</literal>,
25561
+ respectively, as described in <xref linkend="locking-rows"/>. Two
25562
+ additional modes are specific to multixacts:
25563
+ <literal>nokeyupd</literal>, used by updates that do not modify key
25564
+ columns, and <literal>upd</literal>, used by updates or deletes that
25565
+ modify key columns.
25566
+ </para></entry>
25567
+ </row>
25543
25568
</tbody>
25544
25569
</tgroup>
25545
25570
</table>
@@ -25548,7 +25573,8 @@ SELECT collation for ('foo' COLLATE "de_DE");
25548
25573
The internal transaction ID type <type>xid</type> is 32 bits wide and
25549
25574
wraps around every 4 billion transactions. However,
25550
25575
the functions shown in <xref linkend="functions-pg-snapshot"/>, except
25551
- <function>age</function> and <function>mxid_age</function>, use a
25576
+ <function>age</function>, <function>mxid_age</function>, and
25577
+ <function>pg_get_multixact_members</function>, use a
25552
25578
64-bit type <type>xid8</type> that does not wrap around during the life
25553
25579
of an installation and can be converted to <type>xid</type> by casting if
25554
25580
required; see <xref linkend="transaction-id"/> for details.
0 commit comments