Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly

Поиск
Список
Период
Сортировка
От Peter Thomas
Тема Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly
Дата
Msg-id 1451602440.227759.1596074707411.JavaMail.zimbra@mccarthy.co.nz
обсуждение исходный текст
Ответ на Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-bugs
Hi Thomas,

pg_controldata -D pgdata

returns

Date/time type storage:               64-bit integers



Regarding the parallel execution on two same-server databases, I can also reproduce the problem running sequentially (same-thread) across the two same-server databases.

(Note: in both parallel and sequential execution the multi-db same-query inserts are both completed before the multi-db same-query updates get executed)

What is interesting is that in either threading case the incorrect timestamp values are written consistently in both databases, which is a down-vote for random corruption.



Regards,

Peter Thomas 

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly
Следующее
От: Peter Thomas
Дата:
Сообщение: Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly