Re: Prepared statement error with UseServerSidePrepare=1

Hi,
The patches together are working. All problems I noticed in psqlodbc 9.3.3 are gone. Thank you very much.
Now, I guess, I have to test my application all over again.
When can I expect a new release of the psqlodbc driver?

Lev Bukovski

-----Original Message-----
From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp]
Sent: 2. kesäkuuta 2014 18:17
To: Bukovski, Lev /External; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Prepared statement error with UseServerSidePrepare=1

(2014/06/02 22:11), lev(dot)bukovski(at)teliasonera(dot)com wrote:
> Hi Hiroshi,
>
> I applied your patch on psqlodbc 9.3.3 (NOT on the head branch).
> Now I can't even get to insert operations, because I get error while application configuration fetch.
>
> I have this CONFIG table, from where I load configuration parameters
> (SELECT VALUE2, VALUE3 FROM CONFIG WHERE VALUE1 = ?) Each execute of the SQL returns one row. So the first execute success, but second returns with 'Null statement result in PGAPI_ExtendedFetch' error.
>
> psqlodbc and mylog files are in attechaments.

Thanks for the report.
Please apply the attached patch also.

It's the same as the one attached in the thread
[ODBC] Problems using SQLFetch on prepared INSERT with RETURNING clause .

regards,
Hiroshi Inoue