Re: [ODBC] [HY000] no error information; Error while preparingparameters

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-memoryconditions 
>> 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.

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