Re: libpq and mysterious "invalid byte sequence for encoding UTF8".

2021-02-02 Thread Jiří Pavlovský
On 02.02.2021 3:53, Tom Lane wrote: > rob stone writes: >> Columns:- maincontact boolean DEFAULT false, >> publdatacontact boolean DEFAULT false, >> invcontact boolean DEFAULT false, >> queries_recipient boolean, >> fakelastname boolean NOT NULL DEFAULT false, >> ar

Re: libpq and mysterious "invalid byte sequence for encoding UTF8".

2021-02-01 Thread Jiří Pavlovský
On 01.02.2021 15:55, Tom Lane wrote: =?UTF-8?B?SmnFmcOtIFBhdmxvdnNrw70=?= writes:     Jan 26 08:40:57 ip-172-16-10-94 postgres[11334]: [113-1] 2021-01-26 09:40:57.505 CET [11334] jira@project-syndicate LOG:  execute :     UPDATE contacts SET Pos = $1::varchar, Title = $2::varchar,

libpq and mysterious "invalid byte sequence for encoding UTF8".

2021-02-01 Thread Jiří Pavlovský
I'm stuck trying to find a cause for > invalid byte sequence for encoding "UTF8". It is an C program using libpq. I'm using `PQexecParams` to execute the SQL query. The offending byte sequence is completely random, sometimes the command even runs ok. I thought I must have a memory allocation iss