diff options
| author | Thomas Munro <tmunro@postgresql.org> | 2020-04-07 11:08:14 +1200 |
|---|---|---|
| committer | Thomas Munro <tmunro@postgresql.org> | 2020-04-07 12:03:59 +1200 |
| commit | aeec457de8a8820368e343e791accffe24dc7198 (patch) | |
| tree | 1e95e2de03595a459bc26717cf4a3bb22163fb83 /doc/src | |
| parent | 4bea576b032d6e5435ef0946194aada314e67691 (diff) | |
| download | postgresql-aeec457de8a8820368e343e791accffe24dc7198.tar.gz postgresql-aeec457de8a8820368e343e791accffe24dc7198.zip | |
Add SQL type xid8 to expose FullTransactionId to users.
Similar to xid, but 64 bits wide. This new type is suitable for use in
various system views and administration functions.
Reviewed-by: Fujii Masao <masao.fujii@oss.nttdata.com>
Reviewed-by: Takao Fujii <btfujiitkp@oss.nttdata.com>
Reviewed-by: Yoshikazu Imai <imai.yoshikazu@fujitsu.com>
Reviewed-by: Mark Dilger <mark.dilger@enterprisedb.com>
Discussion: https://postgr.es/m/20190725000636.666m5mad25wfbrri%40alap3.anarazel.de
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 03971822c29..89f3a7c1196 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -4517,6 +4517,10 @@ INSERT INTO mytable VALUES(-1); -- fails </indexterm> <indexterm zone="datatype-oid"> + <primary>xid8</primary> + </indexterm> + + <indexterm zone="datatype-oid"> <primary>cid</primary> </indexterm> @@ -4719,6 +4723,9 @@ SELECT * FROM pg_attribute Another identifier type used by the system is <type>xid</type>, or transaction (abbreviated <abbrev>xact</abbrev>) identifier. This is the data type of the system columns <structfield>xmin</structfield> and <structfield>xmax</structfield>. Transaction identifiers are 32-bit quantities. + In some contexts, a 64-bit variant <type>xid8</type> is used. Unlike + <type>xid</type> values, <type>xid8</type> values increase strictly + monotonically and cannot be reused in the lifetime of a database cluster. </para> <para> |