@@ -27687,6 +27687,31 @@ acl | {postgres=arwdDxtm/postgres,foo=r/postgres}
27687
27687
details.
27688
27688
</para></entry>
27689
27689
</row>
27690
+
27691
+ <row>
27692
+ <entry role="func_table_entry"><para role="func_signature">
27693
+ <indexterm>
27694
+ <primary>pg_get_multixact_members</primary>
27695
+ </indexterm>
27696
+ <function>pg_get_multixact_members</function> ( <parameter>multixid</parameter> <type>xid</type> )
27697
+ <returnvalue>setof record</returnvalue>
27698
+ ( <parameter>xid</parameter> <type>xid</type>,
27699
+ <parameter>mode</parameter> <type>text</type> )
27700
+ </para>
27701
+ <para>
27702
+ Returns the transaction ID and lock mode for each member of the
27703
+ specified multixact ID. The lock modes <literal>forupd</literal>,
27704
+ <literal>fornokeyupd</literal>, <literal>sh</literal>, and
27705
+ <literal>keysh</literal> correspond to the row-level locks
27706
+ <literal>FOR UPDATE</literal>, <literal>FOR NO KEY UPDATE</literal>,
27707
+ <literal>FOR SHARE</literal>, and <literal>FOR KEY SHARE</literal>,
27708
+ respectively, as described in <xref linkend="locking-rows"/>. Two
27709
+ additional modes are specific to multixacts:
27710
+ <literal>nokeyupd</literal>, used by updates that do not modify key
27711
+ columns, and <literal>upd</literal>, used by updates or deletes that
27712
+ modify key columns.
27713
+ </para></entry>
27714
+ </row>
27690
27715
</tbody>
27691
27716
</tgroup>
27692
27717
</table>
@@ -27695,7 +27720,8 @@ acl | {postgres=arwdDxtm/postgres,foo=r/postgres}
27695
27720
The internal transaction ID type <type>xid</type> is 32 bits wide and
27696
27721
wraps around every 4 billion transactions. However,
27697
27722
the functions shown in <xref linkend="functions-pg-snapshot"/>, except
27698
- <function>age</function> and <function>mxid_age</function>, use a
27723
+ <function>age</function>, <function>mxid_age</function>, and
27724
+ <function>pg_get_multixact_members</function>, use a
27699
27725
64-bit type <type>xid8</type> that does not wrap around during the life
27700
27726
of an installation and can be converted to <type>xid</type> by casting if
27701
27727
required; see <xref linkend="transaction-id"/> for details.
0 commit comments