Re: the include-timestamp data returned by pg_logical_slot_peek_changes() is always 2000-01-01 in 9.5.1 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: the include-timestamp data returned by pg_logical_slot_peek_changes() is always 2000-01-01 in 9.5.1
Date
Msg-id 92E57CB4-CC68-4471-A459-FD96FF78139D@anarazel.de
Whole thread Raw
In response to Re: the include-timestamp data returned by pg_logical_slot_peek_changes() is always 2000-01-01 in 9.5.1  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: the include-timestamp data returned by pg_logical_slot_peek_changes() is always 2000-01-01 in 9.5.1
List pgsql-hackers

On March 9, 2016 4:26:01 AM PST, Craig Ringer <craig@2ndquadrant.com> wrote:
>On 9 March 2016 at 18:13, 李海龙 <hailong.li@qunar.com> wrote:
>
>>
>>
>> HI, pgsql-hackers
>>
>> The include-timestamp data returned by 
>pg_logical_slot_peek_changes() is
>> always 2000-01-01 in 9.5.1, is it not normal?

It's a bug in 9.5, that has been fixed. You can either update to the version from git, wait for the next minor release,
oruse 9.4, where the buff is not present.
 

>Did you enable track_commit_timestamps in the server?

That's unrelated, commit ts is about an xid timestamp mapping.

Andres
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: More stable query plans via more predictable column statistics
Next
From: Christian Ullrich
Date:
Subject: Re: Crash with old Windows on new CPU