Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly - Mailing list pgsql-bugs

From Peter Thomas
Subject Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly
Date
Msg-id 1451602440.227759.1596074707411.JavaMail.zimbra@mccarthy.co.nz
Whole thread Raw
In response to Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly  (Thomas Munro <thomas.munro@gmail.com>)
List 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 by date:

Previous
From: Thomas Munro
Date:
Subject: Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly
Next
From: Peter Thomas
Date:
Subject: Re: BUG #16561: timestamp with time zone microseconds inconsistently recorded correctly and incorrectly