Re: upgrade from 7.4 to 8.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: upgrade from 7.4 to 8.3
Date
Msg-id 26099.1236775641@sss.pgh.pa.us
Whole thread Raw
In response to Re: upgrade from 7.4 to 8.3  (Marc Cuypers <m.cuypers@mgvd.be>)
List 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 by date:

Previous
From: Marc Cuypers
Date:
Subject: Re: upgrade from 7.4 to 8.3
Next
From: Merlin Moncure
Date:
Subject: Re: ERROR: table row type and query-specified row type do not match