Re: [ODBC] [HY000] no error information; Error while preparingparameters - Mailing list pgsql-odbc

From Daniil Megrabyan
Subject Re: [ODBC] [HY000] no error information; Error while preparingparameters
Date
Msg-id 959A13E2-FB1C-41D6-A07D-BD52F694FE03@gmail.com
Whole thread Raw
In response to Re: [ODBC] [HY000] no error information; Error while preparingparameters  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [ODBC] [HY000] no error information; Error while preparingparameters
List pgsql-odbc
> 6 февр. 2017 г., в 0:49, Adrian Klaver <adrian.klaver@aklaver.com> написал(а):
>
> On 02/05/2017 12:58 PM, Inoue, Hiroshi wrote:
>> On 2017/02/05 22:03, Inoue, Hiroshi wrote:
>>>
>>>
>>> On 2017/02/05 17:30, Daniil Megrabyan wrote:
>>>>> 5 февр. 2017 г., в 11:20, Inoue, Hiroshi <h-inoue@dream.email.ne.jp>
>>>>> написал(а):
>>>>>
>>>>> This means
>>>>>         pgres = PQprepare(conn->pqconn, plan_name, query,
>>>>> num_params, paramTypes);
>>>>> returns a null pointer.
>>>>> https://www.postgresql.org/docs/9.6/static/libpq-exec.html says
>>>>> Returns a PGresult pointer or possibly a null pointer. A non-null
>>>>> pointer will generally be returned except in out-of-memory conditions
>>>>> or serious errors such as inability to send the command to the server.
>>>> I believe, you can reproduce by your own.
>>>
>>> I tried on Windows and Linux but can't reproduce the case.
>>> I have no mac Environment unfortunately.
>>
>> I recommend you to check the server log.
>> I now doubt your program really calls PQprepare() in libpq.
>
> Hmm, this got me to wondering.
>
> If I recall OS X ships with its own version of Postgres.
>
> Can you search for what libpq versions you might have installed on your machine?
>
> Also from your first post you have:
>
> PostgreSQL 9.5.4_1
>
> This is not Postgres community version number(the _1 part), so where did you get it and/or install it?
This is homebrew(http://brew.sh) version, actual version is

bash-3.2$ pg_ctl --version
pg_ctl (PostgreSQL) 9.5.4

— Daniil A Megrabyan —




pgsql-odbc by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [ODBC] [HY000] no error information; Error while preparingparameters
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: [ODBC] Problem calling a function from ODBC application