• Andres Freund's avatar
    logical decoding: fix decoding of a commit's commit time. · 7c17aac6
    Andres Freund authored
    When adding replication origins in 5aa23504, I somehow managed to set
    the timestamp of decoded transactions to InvalidXLogRecptr when decoding
    one made without a replication origin. Fix that, and the wrong type of
    the new commit_time variable.
    
    This didn't trigger a regression test failure because we explicitly
    don't show commit timestamps in the regression tests, as they obviously
    are variable. Add a test that checks that a decoded commit's timestamp
    is within minutes of NOW() from before the commit.
    
    Reported-By: Weiping Qu
    Diagnosed-By: Artur Zakirov
    Discussion: 56D4197E.9050706@informatik.uni-kl.de,
        56D42918.1010108@postgrespro.ru
    Backpatch: 9.5, where 5aa23504 originates.
    7c17aac6
decode.c 25.3 KB