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

On 02/05/2017 10:47 PM, Daniil Megrabyan wrote:
>
>> 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?

Is there more then one version of libpq?

>>
>> 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 —
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com