EPgError: portal "PORTALSTxxxxxxx" does not exist

[radub]

Hello,

Having a ClientDataset, a Provider and a PgQuery with FetchAll=false, along with 2 tables, the following query failed with an error with the text similar with the title.

• with tbl as (Select 'ABC' VAL)
  select a.ID, tbl.VAL
  from tbl1 a
  join tbl2 b on a.ID=b.ID, tbl

If the select in query is from a single table or the query doesn't contain the "with" CTE option or FetchAll=true, the error doesn't raise.

[AlexP]

Hello,

We cannot reproduce the problem. Please try to reproduce the problem on the latest PgDAC version 4.2.6

[radub]

I have sent a mail with a demo.

regards

[AlexP]

Thank you, we have received your sample. We will inform you as soon as we have any results.

[radub]

Issue resolved.
Case closed.

[AlexP]

Glad to see that the issue was resolved. If any other questions come up, please contact us.

[[email protected]]

Hello.

Do you have any information how to resolve this problem? I have exactly the same error.

[azyk]

To solve this issue, download the latest version of PgDAC from our website: http://www.devart.com/pgdac/download.html , and update it. Let us know if the issue is reproduce on the latest version.