Data Compare of Interval Columns

Data Compare of Interval Columns

Postby 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?
jrogovsky
 
Posts: 11
Joined: Thu 06 Apr 2017 21:36

Re: Data Compare of Interval Columns

Postby alexa » Fri 07 Apr 2017 09:01

We will investigate this issue and will answer you as soon as possible.
alexa
Devart Team
 
Posts: 1869
Joined: Fri 24 Jun 2011 14:17

Re: Data Compare of Interval Columns

Postby alexa » Fri 07 Apr 2017 09:47

Could you please provide us the CREATE definition of the table?
alexa
Devart Team
 
Posts: 1869
Joined: Fri 24 Jun 2011 14:17

Re: Data Compare of Interval Columns

Postby 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?
jrogovsky
 
Posts: 11
Joined: Thu 06 Apr 2017 21:36

Re: Data Compare of Interval Columns

Postby alexa » Fri 07 Apr 2017 15:13

Sure. You can send it to our support system at supportATdevartDOTcom and alexaATdevartDOTcom .
alexa
Devart Team
 
Posts: 1869
Joined: Fri 24 Jun 2011 14:17

Re: Data Compare of Interval Columns

Postby 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.
jrogovsky
 
Posts: 11
Joined: Thu 06 Apr 2017 21:36

Re: Data Compare of Interval Columns

Postby 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
Devart Team
 
Posts: 1869
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for PostgreSQL