Re: upgrade from 7.4 to 8.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: upgrade from 7.4 to 8.3
Дата
Msg-id 26099.1236775641@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: upgrade from 7.4 to 8.3  (Marc Cuypers <m.cuypers@mgvd.be>)
Список pgsql-general
Marc Cuypers <m.cuypers@mgvd.be> writes:
> Can i only use nl_BE and UTF-8 now?
> Why can't i use LATIN9 anymore?

The server-side encoding has to be compatible with the locale.
(7.4 didn't really *work* in this situation, as I'm surprised
you failed to notice.)

What you can do is keep the database encoding utf8, and do
ALTER DATABASE SET client_encoding = latin9
so that it looks like latin9 from the client side.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Marc Cuypers
Дата:
Сообщение: Re: upgrade from 7.4 to 8.3
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: ERROR: table row type and query-specified row type do not match