pgsql: Add SQL type xid8 to expose FullTransactionId to users.

From: Thomas Munro <tmunro(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add SQL type xid8 to expose FullTransactionId to users.
Date: 2020-04-07 00:14:03
Message-ID: E1jLbsR-000279-5l@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(dot)fujii(at)oss(dot)nttdata(dot)com>
Reviewed-by: Takao Fujii <btfujiitkp(at)oss(dot)nttdata(dot)com>
Reviewed-by: Yoshikazu Imai <imai(dot)yoshikazu(at)fujitsu(dot)com>
Reviewed-by: Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>
Discussion: https://postgr.es/m/20190725000636.666m5mad25wfbrri%40alap3.anarazel.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/aeec457de8a8820368e343e791accffe24dc7198

Modified Files
--------------
doc/src/sgml/datatype.sgml | 7 ++
src/backend/access/hash/hashvalidate.c | 3 +
src/backend/utils/adt/xid.c | 116 ++++++++++++++++++++++++++
src/fe_utils/print.c | 1 +
src/include/access/transam.h | 14 ++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_amop.dat | 22 +++++
src/include/catalog/pg_amproc.dat | 8 ++
src/include/catalog/pg_cast.dat | 4 +
src/include/catalog/pg_opclass.dat | 4 +
src/include/catalog/pg_operator.dat | 25 ++++++
src/include/catalog/pg_opfamily.dat | 4 +
src/include/catalog/pg_proc.dat | 36 ++++++++
src/include/catalog/pg_type.dat | 4 +
src/include/utils/xid8.h | 22 +++++
src/test/regress/expected/opr_sanity.out | 7 ++
src/test/regress/expected/xid.out | 136 +++++++++++++++++++++++++++++++
src/test/regress/parallel_schedule | 2 +-
src/test/regress/serial_schedule | 1 +
src/test/regress/sql/xid.sql | 48 +++++++++++
20 files changed, 464 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2020-04-07 02:22:22 pgsql: Fix representation of SORT_TYPE_STILL_IN_PROGRESS.
Previous Message Tomas Vondra 2020-04-06 23:18:16 pgsql: Use INT64_FORMAT when formatting int64 values in explain