Re: PG8.3->10 migration data differences

Then fix your field-based data comparing mechanism.

On 09/11/2018 03:41 AM, Csaba Ragasits wrote:
> Hello,
>
> We would like to migrate from 8.3 to 10 version. We've hundreds databases 
> with different structures. That reason we're working on an automatic data 
> comparing process.
>
> I've found the following storage settings:
> - pg83: Date/time type storage:               64-bit integers
> - pg10: Date/time type storage:               64-bit integers
>
> When I running the following select from psql (Select '09/10/18 
> 07:10:25.110'::timestamp;)
> The results are same:
> -pg83: 2018-09-10 07:10:25.11
> -pg10: 2018-09-10 07:10:25.11
>
> When I select it from a table (Select v.entry_timestamp from t_vis v):
> The results are different:
> - pg83: 2015-08-28 21:25:07.70
> - pg10: 2015-08-28 21:25:07.7
>
> The field type:
> entry_timestamp TIMESTAMP WITHOUT TIME ZONE NOT NULL,
>
> Our difference every time the last 0 values. The time values are same, but 
> our field based data comparing mechanism every time mark it as error.
>
> thx,
> Csaba

-- 
Angular momentum makes the world go 'round.