• Michael Paquier's avatar
    Include replication origins in SQL functions for commit timestamp · b1e48bbe
    Michael Paquier authored
    This includes two changes:
    - Addition of a new function pg_xact_commit_timestamp_origin() able, for
    a given transaction ID, to return the commit timestamp and replication
    origin of this transaction.  An equivalent function existed in
    pglogical.
    - Addition of the replication origin to pg_last_committed_xact().
    
    The commit timestamp manager includes already APIs able to return the
    replication origin of a transaction on top of its commit timestamp, but
    the code paths for replication origins were never stressed as those
    functions have never looked for a replication origin, and the SQL
    functions available have never included this information since their
    introduction in 73c986ad.
    
    While on it, refactor a test of modules/commit_ts/ to use tstzrange() to
    check that a transaction timestamp is within the wanted range, making
    the test a bit easier to read.
    
    Bump catalog version.
    
    Author: Movead Li
    Reviewed-by: Madan Kumar, Michael Paquier
    Discussion: https://postgr.es/m/2020051116430836450630@highgo.ca
    b1e48bbe
commit_timestamp_1.out 3.77 KB