Re: [INTERFACES] NOTICE: Unrecognized variable client_encoding - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] NOTICE: Unrecognized variable client_encoding
Date
Msg-id 7115.938212585@sss.pgh.pa.us
Whole thread Raw
In response to NOTICE: Unrecognized variable client_encoding  (Bishop <james.bishop@jrc.it>)
List pgsql-interfaces
Bishop <james.bishop@jrc.it> writes:
> to be reliable. Since compiling PostgreSQL 6.5.2 I have seen "NOTICE:
> unrecognized variable client_encoding" messages, although data do not
> appear to be getting lost or corrupted. Is this message important, or
> can I safely ignore it?

Evidently you compiled the server without the MULTIBYTE option, but
are invoking it with a client whose libpq was compiled with the option.
libpq is trying to tell the server what multibyte character set it
wants to use, and the server is responding that it hasn't got that
feature.

If you aren't worried about non-US-ASCII characters then leaving
MULTIBYTE off is good; otherwise you may want to rebuild with it on.
In any case, to get rid of the notice you'd need to build the client
library with the same options as the server.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Bishop
Date:
Subject: NOTICE: Unrecognized variable client_encoding
Next
From: Jyry Kuukkanen
Date:
Subject: Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !