Re: Prepared statement error with UseServerSidePrepare=1

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: lev(dot)bukovski(at)teliasonera(dot)com, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Prepared statement error with UseServerSidePrepare=1
Date: 2014-06-02 15:16:51
Message-ID: 538C9563.7020401@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

(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

Attachment Content-Type Size
insertreturning_twice.patch text/x-patch 555 bytes

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2014-06-02 16:00:50 Re: Mentioning CPU for Windows build in docs
Previous Message lev.bukovski 2014-06-02 13:11:08 Re: Prepared statement error with UseServerSidePrepare=1