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

Commitbd2ef63

Browse files
committed
Move txid snapshot field description table from datatype to functions section.
1 parentf5f3753 commitbd2ef63

File tree

2 files changed

+60
-78
lines changed

2 files changed

+60
-78
lines changed

‎doc/src/sgml/datatype.sgml‎

Lines changed: 1 addition & 72 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.213 2007/11/0514:51:08 momjian Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.214 2007/11/0516:45:52 momjian Exp $ -->
22

33
<chapter id="datatype">
44
<title id="datatype-title">Data Types</title>
@@ -3437,77 +3437,6 @@ SELECT to_tsquery('Fat:ab & Cats');
34373437

34383438
</sect1>
34393439

3440-
<sect1 id="datatype-txid-snapshot">
3441-
<title>Transaction Snapshot Type</title>
3442-
3443-
<indexterm zone="datatype-txid-snapshot">
3444-
<primary>txid_snapshot</primary>
3445-
</indexterm>
3446-
3447-
<para>
3448-
The data type <type>txid_snapshot</type> stores info about transaction ID
3449-
visibility at a particular moment in time. The components are
3450-
described in <xref linkend="datatype-txid-snapshot-parts">.
3451-
</para>
3452-
3453-
<table id="datatype-txid-snapshot-parts">
3454-
<title>Snapshot components</title>
3455-
<tgroup cols="2">
3456-
<thead>
3457-
<row>
3458-
<entry>Name</entry>
3459-
<entry>Query Function</entry>
3460-
<entry>Description</entry>
3461-
</row>
3462-
</thead>
3463-
3464-
<tbody>
3465-
3466-
<row>
3467-
<entry><type>xmin</type></entry>
3468-
<entry>txid_snapshot_xmin()</entry>
3469-
<entry>
3470-
Earliest transaction ID that is still active. All earlier
3471-
transactions will either be committed and visible, or rolled
3472-
back and dead.
3473-
</entry>
3474-
</row>
3475-
3476-
<row>
3477-
<entry><type>xmax</type></entry>
3478-
<entry>txid_snapshot_xmax()</entry>
3479-
<entry>
3480-
Next unassigned txid. All txids later than this one are
3481-
unassigned, and thus invisible.
3482-
</entry>
3483-
</row>
3484-
3485-
<row>
3486-
<entry><type>xip_list</type></entry>
3487-
<entry>txid_snapshot_xip()</entry>
3488-
<entry>
3489-
Active txids at the time of snapshot. All of them are between
3490-
xmin and xmax. A txid that is <literal>xmin &lt;= txid &lt;
3491-
xmax</literal> and not in this list is visible.
3492-
</entry>
3493-
</row>
3494-
3495-
</tbody>
3496-
</tgroup>
3497-
</table>
3498-
3499-
<para>
3500-
Snapshot's textual representation is <literal>[xmin]:[xmax]:[xip_list]</literal>
3501-
for example <literal>10:20:10,14,15</literal> means
3502-
<literal>xmin=10 xmax=20 xip_list=10,14,15</literal>.
3503-
</para>
3504-
3505-
<para>
3506-
Functions for getting and querying transaction ids and snapshots are
3507-
described in <xref linkend="functions-txid">.
3508-
</para>
3509-
</sect1>
3510-
35113440
<sect1 id="datatype-uuid">
35123441
<title><acronym>UUID</acronym> Type</title>
35133442

‎doc/src/sgml/func.sgml‎

Lines changed: 59 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.407 2007/11/0514:51:08 momjian Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.408 2007/11/0516:45:52 momjian Exp $ -->
22

33
<chapter id="functions">
44
<title>Functions and Operators</title>
@@ -11519,11 +11519,6 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
1151911519
<primary>txid_visible_in_snapshot</primary>
1152011520
</indexterm>
1152111521

11522-
<para>
11523-
The functions shown in <xref linkend="functions-txid-snapshot">
11524-
export server internal transaction info to user level.
11525-
</para>
11526-
1152711522
<table id="functions-txid-snapshot">
1152811523
<title>Transaction IDs and snapshots</title>
1152911524
<tgroup cols="3">
@@ -11575,6 +11570,64 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
1157511570
which transactions were committed between two snapshots.
1157611571
</para>
1157711572

11573+
<para>
11574+
The data type <type>txid_snapshot</type> stores info about transaction ID
11575+
visibility at a particular moment in time. The components are
11576+
described in <xref linkend="datatype-txid-snapshot-parts">.
11577+
</para>
11578+
11579+
<table id="datatype-txid-snapshot-parts">
11580+
<title>Snapshot components</title>
11581+
<tgroup cols="2">
11582+
<thead>
11583+
<row>
11584+
<entry>Name</entry>
11585+
<entry>Query Function</entry>
11586+
<entry>Description</entry>
11587+
</row>
11588+
</thead>
11589+
11590+
<tbody>
11591+
11592+
<row>
11593+
<entry><type>xmin</type></entry>
11594+
<entry>txid_snapshot_xmin()</entry>
11595+
<entry>
11596+
Earliest transaction ID that is still active. All earlier
11597+
transactions will either be committed and visible, or rolled
11598+
back and dead.
11599+
</entry>
11600+
</row>
11601+
11602+
<row>
11603+
<entry><type>xmax</type></entry>
11604+
<entry>txid_snapshot_xmax()</entry>
11605+
<entry>
11606+
Next unassigned txid. All txids later than this one are
11607+
unassigned, and thus invisible.
11608+
</entry>
11609+
</row>
11610+
11611+
<row>
11612+
<entry><type>xip_list</type></entry>
11613+
<entry>txid_snapshot_xip()</entry>
11614+
<entry>
11615+
Active txids at the time of snapshot. All of them are between
11616+
xmin and xmax. A txid that is <literal>xmin &lt;= txid &lt;
11617+
xmax</literal> and not in this list is visible.
11618+
</entry>
11619+
</row>
11620+
11621+
</tbody>
11622+
</tgroup>
11623+
</table>
11624+
11625+
<para>
11626+
Snapshot's textual representation is <literal>[xmin]:[xmax]:[xip_list]</literal>
11627+
for example <literal>10:20:10,14,15</literal> means
11628+
<literal>xmin=10 xmax=20 xip_list=10,14,15</literal>.
11629+
</para>
11630+
1157811631
</sect1>
1157911632

1158011633
<sect1 id="functions-admin">

0 commit comments

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