TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
AndreyD
Posts: 3
Joined: Fri 13 Dec 2019 11:24

TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01

Post by AndreyD » Thu 25 Mar 2021 05:18

Query field value for date 2000-01-01 returns null with TPgConnection.Options.EnablePgTimeStamps set to true .

I'm using PgDAC 6.1.

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01

Post by oleg0k » Mon 29 Mar 2021 15:25

Hello,
Thank you for the information. We've reproduced the issue and are currently working to resolve it. We'll keep you updated on the progress.

wbr, Oleg
Devart Team

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01

Post by oleg0k » Tue 30 Mar 2021 09:20

Hello,
We've fixed the issue with bug for '2000-01-01'. The change will be included in the next release. If you urgently need the fix, we can send you the nightly build. Please send us your PgDAC license number and IDE version, using the form: https://devart.com/company/contactform.html

wbr, Oleg
Devart Team

AndreyD
Posts: 3
Joined: Fri 13 Dec 2019 11:24

Re: TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01

Post by AndreyD » Tue 30 Mar 2021 17:05

Thanks, I'll wait for the new release.

Trying to migrate to 6.4.1 I have found another issue: query hangs up trying to run after any sql error.

Steps to reproduce:
1. Open and run PgDacDemo.
2. Connect to DB.
3. Go to the Query node.
4. Type any wrong query (for example,"select qqq"), click Open. Get SQL exception.
5. Click Open again. The app hangs up forever.

PostgreSQL 11.11, Delphi 7.

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01

Post by oleg0k » Mon 05 Apr 2021 12:25

Hello,
We've released a new version (6.4.2) of the PgDAC. Please try to install the new version and let us know if this helps.

wbr, Oleg
Devart Team

Post Reply