Index: doc/src/sgml/datatype.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v retrieving revision 1.211 diff -c -c -r1.211 datatype.sgml *** doc/src/sgml/datatype.sgml 21 Oct 2007 20:04:37 -0000 1.211 --- doc/src/sgml/datatype.sgml 5 Nov 2007 14:35:49 -0000 *************** *** 3437,3442 **** --- 3437,3513 ---- + + Transaction Snapshot Type + + + txid_snapshot + + + + The data type txid_snapshot stores info about transaction ID + visibility at a particular moment in time. The components are + described in . + + + + Snapshot components + + + + Name + Query Function + Description + + + + + + + xmin + txid_snapshot_xmin() + + Earliest transaction ID that is still active. All earlier + transactions will either be committed and visible, or rolled + back and dead. + + + + + xmax + txid_snapshot_xmax() + + Next unassigned txid. All txids later than this one are + unassigned, and thus invisible. + + + + + xip_list + txid_snapshot_xip() + + Active txids at the time of snapshot. All of them are between + xmin and xmax. A txid that is xmin <= txid < + xmax and not in this list is visible. + + + + + +
+ + + Snapshot's textual representation is [xmin]:[xmax]:[xip_list] + for example 10:20:10,14,15 means + xmin=10 xmax=20 xip_list=10,14,15. + + + + Functions for getting and querying transaction ids and snapshots are + described in . + +
+ <acronym>UUID</acronym> Type Index: doc/src/sgml/func.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/func.sgml,v retrieving revision 1.406 diff -c -c -r1.406 func.sgml *** doc/src/sgml/func.sgml 30 Oct 2007 19:06:56 -0000 1.406 --- doc/src/sgml/func.sgml 5 Nov 2007 14:35:50 -0000 *************** *** 11490,11495 **** --- 11490,11500 ---- as well. + + + + Transaction ID and Snapshot Functions + txid_current *************** *** 11562,11581 **** ! The internal transaction ID type (xid) is 32 bits wide and so ! it wraps around every 4 billion transactions. However, these functions ! export a 64-bit format that is extended with an epoch counter ! so that it will not wrap around for the life of an installation. ! ! System Administration Functions ! ! shows the functions ! available to query and alter run-time configuration parameters. ! Configuration Settings Functions --- 11567,11589 ----
! The internal transaction ID type (xid) is 32 bits wide and ! so it wraps around every 4 billion transactions. However, these ! functions export a 64-bit format that is extended with an ! epoch counter so that it will not wrap around for the life ! of an installation. The main use of these functions is to determine ! which transactions were committed between two snapshots. +
! ! System Administration Functions ! ! shows the functions ! available to query and alter run-time configuration parameters. ! Configuration Settings Functions