Devart Forums

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?

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

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

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

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

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.

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.

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.