Re: PG8.3->10 migration data differences

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: PG8.3->10 migration data differences
Дата
Msg-id b7e21ca6-c795-2cda-4873-ae8cd80383a8@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на PG8.3->10 migration data differences  (Csaba Ragasits <ragasits.csaba@gmail.com>)
Ответы Re: PG8.3->10 migration data differences
Список pgsql-general
Дерево обсуждения
On 10/09/2018 11:22, Csaba Ragasits wrote:
Hello,

We would like to migrate our old databases to new postgres server, with the simple backup-restore process. The process run fine without errors but when we're  checking the source and the migrated datas as field level, we found the following differences:

For example:

Field type: TIMESTAMP WITHOUT TIME ZONE NOT NULL
pg93: 2015-08-28 21:25:07.70
pg10: 2015-08-28 21:25:07.7
Those two are absolutely the same value. 7/10 = 70/100

Field type: REAL
pg93: 2.2
pg10: 2.20000005

Those have to do with rounding. Precision for real is 6 decimal digits. Your difference is on the 8-th digit.
When I check the 8.3 pg_dump file, it contains the pg83 correct values.

Do you have any ideas, why different this values?

Thx,
Csaba 



-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

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