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

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

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