Version 6.3.12 & PostgreSQL & TIMESTAMP

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Bert1234
Posts: 8
Joined: Fri 25 Mar 2016 15:36

Version 6.3.12 & PostgreSQL & TIMESTAMP

Post by Bert1234 » Fri 06 May 2016 09:38

With version 6.3.12, when I set a DateTime value using a TUniTable component, the millisecond part of the value is always 0 in the table.
I have tested with PostgreSQL 9.5.2.

After downgrading to 6.2.10 everything is okay again.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Version 6.3.12 & PostgreSQL & TIMESTAMP

Post by azyk » Tue 10 May 2016 07:47

We can't reproduce the described problem on the latest UniDAC version. Please try to compose a small sample reproducing the isuue and send it to andreyz*devart*com. Using the pg_dump standard utility, create a test database dump, on which the issue is reproduced and include the dump to the sample.

In addition, let us know Windows regional settings on the client machine. For this, open in explorer Control Panel\Clock, Language, and Region , click Region, let us know the value of the Format checkbox on the Formats tab. Switch to the Administrative tab and let us know the value of the 'Current language for non-Unicode programs:' option.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Version 6.3.12 & PostgreSQL & TIMESTAMP

Post by azyk » Wed 11 May 2016 11:05

We have reproduced the issue using your sample. It is most likely related not to UniDAC version, but to PostgreSQL 9.5.2 specificities, since we have checked UniDAC 6.3.12 functioning on servers 9.5.0 and 9.5.1 and haven't detected this issue. We are currently investigating the issue and we'll inform you about the results.

Bert1234
Posts: 8
Joined: Fri 25 Mar 2016 15:36

Re: Version 6.3.12 & PostgreSQL & TIMESTAMP

Post by Bert1234 » Wed 25 May 2016 12:55

What is the status of this issue?
Two weeks have passed since the last message and since then PostgreSQL 9.5.3 has been released. Has it been fixed in this version?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Version 6.3.12 & PostgreSQL & TIMESTAMP

Post by MaximG » Thu 26 May 2016 10:26

We continue investigation of the issue when working with TimeStamp fields. We are checking the behavior of UniDAC on different versions of PostgreSQL , including the PostgreSQL version 9.5.3. We will inform you about the results shortly.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Version 6.3.12 & PostgreSQL & TIMESTAMP

Post by MaximG » Thu 16 Jun 2016 05:10

We have already fixed the error, and the fix will be included in the next build. We plan to release the build next week.

Post Reply