Query executed twice.

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tnx
Posts: 10
Joined: Mon 16 Mar 2009 17:52

Query executed twice.

Post by tnx » Mon 06 Apr 2009 12:37

Hello

When I run a PlPgSQL function that has a void return value (no return value), and I run the query like 'select myfunction()' using TPgQuery.Open (not .Execute), the query is run twice. Why is that?

I can see two identical TCP/IP packets sent in WireShark and the work is done twice in PostgreSQL. In my case, I get a constraint violation, which is not acceptable.

Thanks for your support.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Wed 08 Apr 2009 08:35

We have fixed this problem. The fix will be included in the next build of PgDAC.

tnx
Posts: 10
Joined: Mon 16 Mar 2009 17:52

Post by tnx » Thu 09 Apr 2009 08:50

Thank you. When do you expect the next build? Is an update possible earlier than the normal build cycles you have (which is an update every 1-2 months).

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 13 Apr 2009 07:36

We are planning to release new build in a month. If you need an update earlier, please contact us by e-mail pgdac*devart*com, specify your licence number and Delphi version.

Post Reply