Data Compare of Interval Columns
Data Compare of Interval Columns
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?
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?
Re: Data Compare of Interval Columns
We will investigate this issue and will answer you as soon as possible.
Re: Data Compare of Interval Columns
Could you please provide us the CREATE definition of the table?
Re: Data Compare of Interval Columns
I'd rather not post it to a public forum. Is there an email address I can send it to?
Re: Data Compare of Interval Columns
Sure. You can send it to our support system at supportATdevartDOTcom and alexaATdevartDOTcom .
Re: Data Compare of Interval Columns
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.
I've sent and email containing a script generated via pgAdmin and a screenshot showing different values in the Interval columns After a sync.
Re: Data Compare of Interval Columns
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 will fix this issue in one of the next product builds and will notify you once it's available for downloading.
Re: Data Compare of Interval Columns
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.
Thank you for your help in improving dbForge Data Compare for PostgreSQL.