• Michael Paquier's avatar
    Redesign pageinspect function printing infomask bits · 58b4cb30
    Michael Paquier authored
    After more discussion, the new function added by ddbd5d87 could have been
    designed in a better way.  Based on an idea from Álvaro, instead of
    returning one column which includes both the raw and combined flags, use
    two columns, with one for the raw flags and one for the combined flags.
    
    This also takes care of some issues with HEAP_LOCKED_UPGRADED and
    HEAP_XMAX_IS_LOCKED_ONLY which are not really combined flags as they
    depend on conditions defined by other raw bits, as mentioned by Amit.
    
    While on it, fix an extra issue with combined flags.  A combined flag
    was returned if at least one of its bits was set, but all its bits need
    to be set to include it in the result.
    
    Author: Michael Paquier
    Reviewed-by: Álvaro Herrera, Amit Kapila
    Discussion: https://postgr.es/m/20190913114950.GA3824@alvherre.pgsql
    58b4cb30
pageinspect--1.7--1.8.sql 505 Bytes