Data Compare of Interval Columns

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
jrogovsky
Posts: 13
Joined: Thu 06 Apr 2017 21:36

Data Compare of Interval Columns

Post by jrogovsky » Fri 07 Apr 2017 00:20

I'm currently evaluating your Data Compare for PostgreSQL product.

The version of PostgreSQL I'm using is 9.2.4 64-bit. I'm developing reports against an existing application so I do not have the option of updating PostgreSQL version.

In comparing two databases with the the same schema, I notice that Interval columns are not always syncing properly.

It looks like it could be a rounding or precision issue.

The source db will have a value like 00:00:05.286 and the destination will be like 00:00:05.285.

I proceed with syncing the data but the value in the destination db does not seem to update.

Any ideas?

alexa

Re: Data Compare of Interval Columns

Post by alexa » Fri 07 Apr 2017 09:01

We will investigate this issue and will answer you as soon as possible.

alexa

Re: Data Compare of Interval Columns

Post by alexa » Fri 07 Apr 2017 09:47

Could you please provide us the CREATE definition of the table?

jrogovsky
Posts: 13
Joined: Thu 06 Apr 2017 21:36

Re: Data Compare of Interval Columns

Post by jrogovsky » Fri 07 Apr 2017 14:51

I'd rather not post it to a public forum. Is there an email address I can send it to?

alexa

Re: Data Compare of Interval Columns

Post by alexa » Fri 07 Apr 2017 15:13

Sure. You can send it to our support system at supportATdevartDOTcom and alexaATdevartDOTcom .

jrogovsky
Posts: 13
Joined: Thu 06 Apr 2017 21:36

Re: Data Compare of Interval Columns

Post by jrogovsky » Fri 07 Apr 2017 20:55

Thank you.

I've sent and email containing a script generated via pgAdmin and a screenshot showing different values in the Interval columns After a sync.

alexa

Re: Data Compare of Interval Columns

Post by alexa » Mon 10 Apr 2017 11:16

Thank you for the reply.

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

alexa

Re: Data Compare of Interval Columns

Post by alexa » Wed 27 Sep 2017 14:16

We would like to let you know that we have released dbForge Data Compare for PostgreSQL, v3.0 where the issue you reported is fixed https://devart.com/dbforge/postgresql/d ... nload.html

Thank you for your help in improving dbForge Data Compare for PostgreSQL.

Post Reply