Re: libpq and mysterious "invalid byte sequence for encoding UTF8". - Mailing list pgsql-general

From Tom Lane
Subject Re: libpq and mysterious "invalid byte sequence for encoding UTF8".
Date
Msg-id 3597100.1612234425@sss.pgh.pa.us
Whole thread Raw
In response to Re: libpq and mysterious "invalid byte sequence for encoding UTF8".  (rob stone <floriparob@gmail.com>)
Responses Re: libpq and mysterious "invalid byte sequence for encoding UTF8".  (Jiří Pavlovský <jiri@pavlovsky.eu>)
List pgsql-general
rob stone <floriparob@gmail.com> writes:
> Columns:- maincontact boolean DEFAULT false,
>         publdatacontact boolean DEFAULT false,
>         invcontact boolean DEFAULT false,
>         queries_recipient boolean,
>         fakelastname boolean NOT NULL DEFAULT false,

> are defined as booleans and all except one have defaults declared, yet
> you are passing NULL's which the insert tries to cast to boolean.
> Maybe this is the cause of the error??

Oooh ... if we posit that the statement is expected to throw an error,
maybe what this error is complaining about is an inability to translate
a localized error message to the client's encoding.  This could reflect
an incorrectly-encoded .po file, for example.  So what we need to know
next is what lc_messages setting Jiří is using, and also the server
and client encodings.

            regards, tom lane



pgsql-general by date:

Previous
From: Matt Zagrabelny
Date:
Subject: Re: count(*) vs count(id)
Next
From: "Jain, Ankit"
Date:
Subject: Issues with using plpgsql debugger using PG13 on Centos 7