Re: [HY000] no error information; Error while preparing parameters

From: Daniil Megrabyan <danil(dot)megrabjan(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [HY000] no error information; Error while preparing parameters
Date: 2017-02-06 06:47:12
Message-ID: 959A13E2-FB1C-41D6-A07D-BD52F694FE03@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


> 6 февр. 2017 г., в 0:49, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(at)dream(dot)email(dot)ne(dot)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 —

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2017-02-06 09:52:36 Re: Problem calling a function from ODBC application
Previous Message Adrian Klaver 2017-02-05 21:49:32 Re: [HY000] no error information; Error while preparing parameters