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

Поиск
Список
Период
Сортировка
Искать

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

От:
Thomas Munro <tmunro@postgresql.org>
Дата:
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 
Reviewed-by: Takao Fujii 
Reviewed-by: Yoshikazu Imai 
Reviewed-by: Mark Dilger 
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(-)

FAQ