{"kind": "oid", "major": "18", "item": {"slug": "xid", "name": "xid", "name_zh": "xid", "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": {"10": {"facts": [{"label": "System columns", "value": "xmin, xmax"}], "related": [{"url": "/docs/10/ddl-system-columns.html", "label": "Section 5.4"}], "release": {"ref": "PostgreSQL 10.23 Documentation", "label": "10.23", "major": "10", "channel": "historical", "revision": "92d3c4a6201e06b2aea6dabfa4867cf6d1b2f66c2eb53b77ed08646b3068c291"}, "sources": [{"url": "/docs/10/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 10.23 Documentation", "sha256": "92d3c4a6201e06b2aea6dabfa4867cf6d1b2f66c2eb53b77ed08646b3068c291"}, {"url": "https://www.postgresql.org/docs/10/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 10 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."]}, "11": {"facts": [{"label": "System columns", "value": "xmin, xmax"}], "related": [{"url": "/docs/11/ddl-system-columns.html", "label": "Section 5.4"}], "release": {"ref": "PostgreSQL 11.22 Documentation", "label": "11.22", "major": "11", "channel": "historical", "revision": "a1cc37e5ce5c2d09ce06539704c618a2d418f54eaaa35365e8c547d2aaa06311"}, "sources": [{"url": "/docs/11/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 11.22 Documentation", "sha256": "a1cc37e5ce5c2d09ce06539704c618a2d418f54eaaa35365e8c547d2aaa06311"}, {"url": "https://www.postgresql.org/docs/11/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 11 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."]}, "12": {"facts": [{"label": "System columns", "value": "xmin, xmax"}], "related": [{"url": "/docs/12/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 12.22 Documentation", "label": "12.22", "major": "12", "channel": "historical", "revision": "5675d9e3b694f46538248a1a9f533609078817a7b6d469c53533973cbfaecc8c"}, "sources": [{"url": "/docs/12/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 12.22 Documentation", "sha256": "5675d9e3b694f46538248a1a9f533609078817a7b6d469c53533973cbfaecc8c"}, {"url": "https://www.postgresql.org/docs/12/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 12 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."]}, "13": {"facts": [{"label": "System columns", "value": "xmin, xmax"}], "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": [{"label": "System columns", "value": "xmin, xmax"}], "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": [{"label": "System columns", "value": "xmin, xmax"}], "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": [{"label": "System columns", "value": "xmin, xmax"}], "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": [{"label": "System columns", "value": "xmin, xmax"}], "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": [{"label": "System columns", "value": "xmin, xmax"}], "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": [{"label": "System columns", "value": "xmin, xmax"}], "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": [{"label": "System columns", "value": "xmin, xmax"}], "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": "a843fead858d38f2a180bd49d568f12c72609c779047fdacefbbc53dd8c6dd2f", "imported_at": "2026-09-27T09:57:59.126"}, "snapshot": {"facts": [{"label": "System columns", "value": "xmin, xmax"}], "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": "17", "right": "18", "status": "unchanged", "diff": ""}}