Horton

Add SQL type xid8 to expose FullTransactionId to users.

Thomas Munro <tmunro@postgresql.org>

View on postgr.es
Commit: aeec457de8a8820368e343e791accffe24dc7198
Author: Thomas Munro <tmunro@postgresql.org>
Date: 2020-04-07T00:03:59Z
Releases: 13.0 
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

Files

PathChange+/−
doc/src/sgml/datatype.sgml modified +7 −0
src/backend/access/hash/hashvalidate.c modified +3 −0
src/backend/utils/adt/xid.c modified +116 −0
src/fe_utils/print.c modified +1 −0
src/include/access/transam.h modified +14 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_amop.dat modified +22 −0
src/include/catalog/pg_amproc.dat modified +8 −0
src/include/catalog/pg_cast.dat modified +4 −0
src/include/catalog/pg_opclass.dat modified +4 −0
src/include/catalog/pg_operator.dat modified +25 −0
src/include/catalog/pg_opfamily.dat modified +4 −0
src/include/catalog/pg_proc.dat modified +36 −0
src/include/catalog/pg_type.dat modified +4 −0
src/include/utils/xid8.h added +22 −0
src/test/regress/expected/opr_sanity.out modified +7 −0
src/test/regress/expected/xid.out added +136 −0
src/test/regress/parallel_schedule modified +1 −1
src/test/regress/serial_schedule modified +1 −0
src/test/regress/sql/xid.sql added +48 −0

Documentation touched

Discussion