Search found 3 matches

by AndreyD
Tue 06 Apr 2021 15:04
Forum: PostgreSQL Data Access Components
Topic: PgDAC 6.4.2 procedure parameters issue
Replies: 3
Views: 17216

PgDAC 6.4.2 procedure parameters issue

TPgSQL does not recognize parameters in procedure calls, i.e:

call somefunction(:param) raises exception "there is no parameter $1".

In the PgDAC 5.3 it worked fine.

PostgreSQL 11.11, Delphi 7.
by AndreyD
Tue 30 Mar 2021 17:05
Forum: PostgreSQL Data Access Components
Topic: TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01
Replies: 4
Views: 17236

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

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.
by AndreyD
Thu 25 Mar 2021 05:18
Forum: PostgreSQL Data Access Components
Topic: TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01
Replies: 4
Views: 17236

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

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

I'm using PgDAC 6.1.