Page 1 of 1

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

Posted: Thu 25 Mar 2021 05:18
by AndreyD
Query field value for date 2000-01-01 returns null with TPgConnection.Options.EnablePgTimeStamps set to true .

I'm using PgDAC 6.1.

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

Posted: Mon 29 Mar 2021 15:25
by oleg0k
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

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

Posted: Tue 30 Mar 2021 09:20
by oleg0k
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

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

Posted: Tue 30 Mar 2021 17:05
by AndreyD
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.

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

Posted: Mon 05 Apr 2021 12:25
by oleg0k
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