{"kind": "oid", "major": "18", "item": {"slug": "xid8", "name": "xid8", "name_zh": "xid8", "category": "Transaction and row identifiers", "summary": "Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 67.1 for more details.", "aliases": [], "versions": {"13": {"facts": [], "related": [{"url": "/docs/13/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 13.23 Documentation", "label": "13.23", "major": "13", "channel": "historical", "revision": "e8d8a34f63902cffef02459d02c2eefdf066463f9cb979c0b0b70f6659ff2bf0"}, "sources": [{"url": "/docs/13/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 13.23 Documentation", "sha256": "e8d8a34f63902cffef02459d02c2eefdf066463f9cb979c0b0b70f6659ff2bf0"}, {"url": "https://www.postgresql.org/docs/13/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 13 online manual"}], "sections": [], "description": ["Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster."]}, "14": {"facts": [], "related": [{"url": "/docs/14/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 14.24 Documentation", "label": "14.24", "major": "14", "channel": "stable", "revision": "b689bc079f1ebb4b03dd138db6e1bef615d018d2cfa6f7108fab7dbdda3282bd"}, "sources": [{"url": "/docs/14/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 14.24 Documentation", "sha256": "b689bc079f1ebb4b03dd138db6e1bef615d018d2cfa6f7108fab7dbdda3282bd"}, {"url": "https://www.postgresql.org/docs/14/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 14 online manual"}], "sections": [], "description": ["Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster."]}, "15": {"facts": [], "related": [{"url": "/docs/15/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 15.19 Documentation", "label": "15.19", "major": "15", "channel": "stable", "revision": "f10a38f34aecafe53113185b7e56d667b2d7d33905acde2aeef4a6fec76ff9d6"}, "sources": [{"url": "/docs/15/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 15.19 Documentation", "sha256": "f10a38f34aecafe53113185b7e56d667b2d7d33905acde2aeef4a6fec76ff9d6"}, {"url": "https://www.postgresql.org/docs/15/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 15 online manual"}], "sections": [], "description": ["Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster."]}, "16": {"facts": [], "related": [{"url": "/docs/16/transaction-id.html", "label": "Section 74.1"}, {"url": "/docs/16/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 16.15 Documentation", "label": "16.15", "major": "16", "channel": "stable", "revision": "24d2f393c5bcc7ff47d33e9a61479d00dcc99825ae296491771e340391f24384"}, "sources": [{"url": "/docs/16/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 16.15 Documentation", "sha256": "24d2f393c5bcc7ff47d33e9a61479d00dcc99825ae296491771e340391f24384"}, {"url": "https://www.postgresql.org/docs/16/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 16 online manual"}], "sections": [], "description": ["Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 74.1 for more details."]}, "17": {"facts": [], "related": [{"url": "/docs/17/transaction-id.html", "label": "Section 66.1"}, {"url": "/docs/17/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 17.11 Documentation", "label": "17.11", "major": "17", "channel": "stable", "revision": "f58cc823839afa25edb5df244b0a27ad24aa1d62d2d14870e9117eda6f619a74"}, "sources": [{"url": "/docs/17/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 17.11 Documentation", "sha256": "f58cc823839afa25edb5df244b0a27ad24aa1d62d2d14870e9117eda6f619a74"}, {"url": "https://www.postgresql.org/docs/17/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 17 online manual"}], "sections": [], "description": ["Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 66.1 for more details."]}, "18": {"facts": [], "related": [{"url": "/docs/18/transaction-id.html", "label": "Section 67.1"}, {"url": "/docs/18/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38"}, "sources": [{"url": "/docs/18/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 18.6 Documentation", "sha256": "8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38"}, {"url": "https://www.postgresql.org/docs/18/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 67.1 for more details."]}, "19": {"facts": [], "related": [{"url": "/docs/19/transaction-id.html", "label": "Section 67.1"}, {"url": "/docs/19/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "1985075ff3a6bdd8f41bf558847d8707b87c3103aff3c86ad4b627ac7f2d3756"}, "sources": [{"url": "/docs/19/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 19beta4 Documentation", "sha256": "1985075ff3a6bdd8f41bf558847d8707b87c3103aff3c86ad4b627ac7f2d3756"}, {"url": "https://www.postgresql.org/docs/19/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 67.1 for more details."]}, "20": {"facts": [], "related": [{"url": "/docs/devel/transaction-id.html", "label": "Section 67.1"}, {"url": "/docs/devel/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "dc75e7ebcf3d74dccbbc22ff10acdddc868b64becff49460d7f6ae89659f8be4"}, "sources": [{"url": "/docs/devel/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 20devel Documentation", "sha256": "dc75e7ebcf3d74dccbbc22ff10acdddc868b64becff49460d7f6ae89659f8be4"}, {"url": "https://www.postgresql.org/docs/devel/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 67.1 for more details."]}}, "content_hash": "0f1b788cd324f2406f1c461f19c76f0ce72fee217e8e373e2e7e4f89721144cb", "imported_at": "2026-09-27T09:57:59.128"}, "snapshot": {"facts": [], "related": [{"url": "/docs/18/transaction-id.html", "label": "Section 67.1"}, {"url": "/docs/18/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38"}, "sources": [{"url": "/docs/18/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 18.6 Documentation", "sha256": "8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38"}, {"url": "https://www.postgresql.org/docs/18/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 67.1 for more details."]}, "comparison": {"left": "12", "right": "13", "status": "added", "diff": "--- PostgreSQL 12\n+++ PostgreSQL 13\n@@ -1 +1,5 @@\n-Not recorded in this version\n+{\n+  \"facts\": [],\n+  \"signature\": null,\n+  \"tables\": null\n+}"}}