Re: [INTERFACES] NOTICE: Unrecognized variable client_encoding

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [INTERFACES] NOTICE: Unrecognized variable client_encoding
Дата
Msg-id 7115.938212585@sss.pgh.pa.us
обсуждение исходный текст
Ответ на NOTICE: Unrecognized variable client_encoding  (Bishop <james.bishop@jrc.it>)
Список 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 по дате отправления:

Предыдущее
От: Bishop
Дата:
Сообщение: NOTICE: Unrecognized variable client_encoding
Следующее
От: Jyry Kuukkanen
Дата:
Сообщение: Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !