Page 1 of 1

Query executed twice.

Posted: Mon 06 Apr 2009 12:37
by tnx
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.

Posted: Wed 08 Apr 2009 08:35
by Plash
We have fixed this problem. The fix will be included in the next build of PgDAC.

Posted: Thu 09 Apr 2009 08:50
by tnx
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).

Posted: Mon 13 Apr 2009 07:36
by Plash
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.