pgsql: Add to pageinspect function to make t_infomask/t_infomask2 human

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add to pageinspect function to make t_infomask/t_infomask2 human
Date: 2019-09-12 06:09:39
Message-ID: E1i8IIV-0004Ti-1Y@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add to pageinspect function to make t_infomask/t_infomask2 human-readable

Flags of t_infomask and t_infomask2 for each tuple are already included
in the information returned by heap_page_items as integers, and we
lacked a way to make that information human-readable.

Per discussion, the function includes an option which controls if
combined flags should be decomposed or not. The default is false, to
not decompose combined flags.

The module is bumped to version 1.8.

Author: Craig Ringer, Sawada Masahiko
Reviewed-by: Peter Geoghegan, Robert Haas, Álvaro Herrera, Moon Insung,
Amit Kapila, Michael Paquier, Tomas Vondra
Discussion: https://postgr.es/m/CAMsr+YEY7jeaXOb+oX+RhDyOFuTMdmHjGsBxL=igCm03J0go9Q@mail.gmail.com

Branch
------
master

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

Modified Files
--------------
contrib/pageinspect/Makefile | 2 +-
contrib/pageinspect/expected/page.out | 180 ++++++++++++++++++++++++++
contrib/pageinspect/heapfuncs.c | 109 ++++++++++++++++
contrib/pageinspect/pageinspect--1.7--1.8.sql | 15 +++
contrib/pageinspect/pageinspect.control | 2 +-
contrib/pageinspect/sql/page.sql | 42 ++++++
doc/src/sgml/pageinspect.sgml | 41 ++++++
7 files changed, 389 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2019-09-12 09:09:30 pgsql: Doc: Update PL/pgSQL sample function in plpgsql.sgml.
Previous Message Michael Paquier 2019-09-12 01:36:19 pgsql: Improve coverage of psql for backslash commands with \if and \el