| 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: | Whole Thread | Raw Message | 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 |
| 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 |