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

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: the include-timestamp data returned by pg_logical_slot_peek_changes() is always 2000-01-01 in 9.5.1
Дата
Msg-id CAMsr+YGXuAS22tWJwBmsMCeadOM9+iegjc2g+aZqLqpPye4xqg@mail.gmail.com
обсуждение исходный текст
Ответ на the include-timestamp data returned by pg_logical_slot_peek_changes() is always 2000-01-01 in 9.5.1  (李海龙 <hailong.li@qunar.com>)
Ответы Re: the include-timestamp data returned by pg_logical_slot_peek_changes() is always 2000-01-01 in 9.5.1  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
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?

Did you enable track_commit_timestamps in the server?

If not, and it's returning  2000-01-01 I think that's a bug - it should return null if timestamps aren't recorded. (We can't really differentiate between the real timestamp 2000-01-01 00:00:00 and the case where we didn't record a timestamp, but I don't think we care about tx's generated on the second of the millennium...)

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: multivariate statistics v11
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: WIP: Access method extendability