(-1/HY000/1) out of memory for query result for getting Bytea

From: "Autade, Kalpana (Kalpana)" <kalpanaautade(at)avaya(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: (-1/HY000/1) out of memory for query result for getting Bytea
Date: 2020-06-08 11:59:27
Message-ID: CY4PR15MB1541FB8B825000D538A99B97A3850@CY4PR15MB1541.namprd15.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

We have C++ application connecting to Postgres 11.2 Using ODBC driver (driver='PSQLODBC35W.DLL', version=09.06.0500)
We are trying to retrieve multiple document simultaneously using below query . We are getting exception sometime.

Error while executing function C3KSQL_F_GET_LOB (8): selectBlob: SQLExecDirect (time: 2500 ms, statement: SELECT DOCFILE FROM XXXXXX WHERE ID = 4148) failed: (-1/HY000/1) out of memory for query result
;
Error while executing the query

Please help on this. Am I using correct ODBC driver?

-Kalpana Autade

Browse pgsql-odbc by date

  From Date Subject
Next Message Michiko Kawamoto 2020-06-12 21:59:53 AWS PostgreSQL Encoding and Connection Issue on JMP
Previous Message Test Last 2020-06-05 15:56:51 ODBC Driver dbg