EPgError with message .......

yapt · Post by **yapt** » Thu 17 Feb 2011 20:26

Hello,

I have installed version 2.10.0.4 from previous major version (1.x, I think). I have maintained my PostgreSQL 8.4 database.

I am testing an already running/production application and I am getting this:
...raised exception class EPgError with message 'el cursor -> ya existe'.

This, translated is more or less:
Cursor PORTALST249512320 already exists

I don't know why this is happening and I could not reproduce it.

I will follow investigating tomorrow. I already have lost all day with this.

Any idea ?

Thanks.

PS: I will submit a support request if tomorrow I have no answer.

AlexP · Post by **AlexP** » Fri 18 Feb 2011 08:08

Hello,

Unfortunately, we didn't receive your e-mail.

Please specify the problem in more details, so that I could reproduce it:
- the exact version of your IDE;
- when does the error arise - on connecting, on executing any queries, etc.?

or send a complete small sample to alexp*devart*com to demonstrate the problem.

yapt · Post by **yapt** » Fri 18 Feb 2011 09:09

Hi Alex,

now is "tomorrow" here...

IDE: Embarcadero® RAD Studio 2010 Version 14.0.3615.26342 (Delphi)
The error is raised on Open a table.

Table:
- is on a DataModule
- has onCalculate event assigned.

I am focusing on only a form to find the exact error. That form is using cxGrid (from DevExpress). If I _simply_ delete my cxGrid, then error is not raised. :-O

I am trying to isolate it (but it is a difficult task because the whole Devart/Devexpress source code jumps) to get a sample app I can send you.

Today I will be focused to solve this or I will have to go back to the previous version of PgDAC. This a production app.

If you prefer, I will continue by mail Alex.

yapt · Post by **yapt** » Fri 18 Feb 2011 10:56

I have sent mail to the mail address you have indicated, but I have no answer if the mail has arrived or not.

Thanks.

AlexP · Post by **AlexP** » Fri 18 Feb 2011 11:55

hello,

I have received your e-mail.
I will notify you as soon as I have any results.

Zog · Post by **Zog** » Sat 19 Feb 2011 15:36

Strange - I am having the same problem. Does it have something to do with this?

http://www.devart.com/forums/viewtopic. ... ght=portal

Also, my code only produces this result when I have a UniTransaction attached to the UniSQL I am using to do inserts. WHen I dont use the transaction it works...

Zog · Post by **Zog** » Sat 19 Feb 2011 16:06

This behavior goes away if I do:

QRY.SpecificOptions.Add('PostgreSQL.UnpreparedExecute=True');

I would still like to know why this is necessary though.

yapt · Post by **yapt** » Sun 20 Feb 2011 20:09

Zog, you are right.... In my problematic PgQuery, I have not:
> UnpreparedExecute = true

but I have:
> AutoPrepare = true

If I set AutoPrepare to False, all runs fine.

Greetings..

yapt · Post by **yapt** » Sun 20 Feb 2011 20:13

That post is an old post with an old PgDac Version....
The "sender" was...... Me. :-O

Really amazing. Perhaps a regression bug ?

Zog wrote:Strange - I am having the same problem. Does it have something to do with this?

http://www.devart.com/forums/viewtopic. ... ght=portal

AlexP · Post by **AlexP** » Mon 21 Feb 2011 08:24

Hello,

We have reproduced the problem.
We will fix the problem in the next build of PgDAC.