Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit6fc3c58

Browse files
committed
doc: Fix section of functions age(xid) and mxid_age(xid)
In 17~, age(xid) and mxid_age(xid) were listed as deprecated. Based onthe discussion that led to48b5aa3, this is not intentional as thiscould break many existing monitoring queries. Note that vacuumdb alsouses both of them.In 16, both functions were listed under "Control Data Functions", whichis incorrect, so let's move them to the list of functions related totransaction IDs and snapshots.Author: Bertrand DrouvotDiscussion:https://postgr.es/m/Zzr2zZFyeFKXWe8a@ip-10-97-1-34.eu-west-3.compute.internalDiscussion:https://postgr.es/m/20231114013224.4z6oxa6p6va33rxr@awork3.anarazel.deBackpatch-through: 16
1 parentc1ebef3 commit6fc3c58

File tree

1 file changed

+30
-28
lines changed

1 file changed

+30
-28
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 30 additions & 28 deletions
Original file line numberDiff line numberDiff line change
@@ -27009,6 +27009,34 @@ SELECT currval(pg_get_serial_sequence('sometable', 'id'));
2700927009
</thead>
2701027010

2701127011
<tbody>
27012+
<row>
27013+
<entry role="func_table_entry"><para role="func_signature">
27014+
<indexterm>
27015+
<primary>age</primary>
27016+
</indexterm>
27017+
<function>age</function> ( <type>xid</type> )
27018+
<returnvalue>integer</returnvalue>
27019+
</para>
27020+
<para>
27021+
Returns the number of transactions between the supplied
27022+
transaction id and the current transaction counter.
27023+
</para></entry>
27024+
</row>
27025+
27026+
<row>
27027+
<entry role="func_table_entry"><para role="func_signature">
27028+
<indexterm>
27029+
<primary>mxid_age</primary>
27030+
</indexterm>
27031+
<function>mxid_age</function> ( <type>xid</type> )
27032+
<returnvalue>integer</returnvalue>
27033+
</para>
27034+
<para>
27035+
Returns the number of multixacts IDs between the supplied
27036+
multixact ID and the current multixacts counter.
27037+
</para></entry>
27038+
</row>
27039+
2701227040
<row>
2701327041
<entry role="func_table_entry"><para role="func_signature">
2701427042
<indexterm>
@@ -27153,7 +27181,8 @@ SELECT currval(pg_get_serial_sequence('sometable', 'id'));
2715327181
<para>
2715427182
The internal transaction ID type <type>xid</type> is 32 bits wide and
2715527183
wraps around every 4 billion transactions. However,
27156-
the functions shown in <xref linkend="functions-pg-snapshot"/> use a
27184+
the functions shown in <xref linkend="functions-pg-snapshot"/>, except
27185+
<function>age</function> and <function>mxid_age</function>, use a
2715727186
64-bit type <type>xid8</type> that does not wrap around during the life
2715827187
of an installation and can be converted to <type>xid</type> by casting if
2715927188
required; see <xref linkend="transaction-id"/> for details.
@@ -27235,33 +27264,6 @@ SELECT currval(pg_get_serial_sequence('sometable', 'id'));
2723527264
</thead>
2723627265

2723727266
<tbody>
27238-
<row>
27239-
<entry role="func_table_entry"><para role="func_signature">
27240-
<indexterm>
27241-
<primary>age</primary>
27242-
</indexterm>
27243-
<function>age</function> ( <type>xid</type> )
27244-
<returnvalue>integer</returnvalue>
27245-
</para>
27246-
<para>
27247-
Returns the number of transactions between the supplied
27248-
transaction id and the current transaction counter.
27249-
</para></entry>
27250-
</row>
27251-
27252-
<row>
27253-
<entry role="func_table_entry"><para role="func_signature">
27254-
<indexterm>
27255-
<primary>mxid_age</primary>
27256-
</indexterm>
27257-
<function>mxid_age</function> ( <type>xid</type> )
27258-
<returnvalue>integer</returnvalue>
27259-
</para>
27260-
<para>
27261-
Returns the number of multixacts IDs between the supplied
27262-
multixact ID and the current multixacts counter.
27263-
</para></entry>
27264-
</row>
2726527267

2726627268
<row>
2726727269
<entry role="func_table_entry"><para role="func_signature">

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp