From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Daniil Megrabyan <danil(dot)megrabjan(at)gmail(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: [HY000] no error information; Error while preparing parameters |
Date: | 2017-02-05 20:58:50 |
Message-ID: | 7b18ca09-43ff-d3a4-dbaf-b3a974b84f1d@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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.
regards,
Hiroshi Inoue
> regards,
> Hiroshi Inoue
>
>>
>> CREATE TABLE core_message (
>> id int8 NOT NULL DEFAULT nextval('core_message_id_seq'::regclass),
>> channel_id int8 NOT NULL,
>> date timestamp(6) NOT NULL,
>> member_id int8 NOT NULL,
>> reply_id int8
>> )
>> WITH (OIDS=FALSE);
>>
>> CREATE TABLE core_textmessage (
>> message_id int8 NOT NULL,
>> text text NOT NULL
>> )
>> WITH (OIDS=FALSE);
>>
>> INSERT INTO core_textmessage(message_id, text) VALUES(1,
>> ‘Мультибайт’) < This UTF8 text does the «magic» and environment
>> becomes unusable
>> INSERT INTO core_message(channel_id, date, member_id, reply_id)
>> VALUES(25, '2017-02-05 11:01:34', 4, NULL)
>>
>> — Daniil A Megrabyan —
>> phone(telegram, whatsapp, viber) : +79151762470 | skype: danil.megrabyan
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-02-05 21:49:32 | Re: [HY000] no error information; Error while preparing parameters |
Previous Message | Inoue, Hiroshi | 2017-02-05 13:03:53 | Re: [HY000] no error information; Error while preparing parameters |