On Mon, Sep 24, 2012 at 11:22:22AM -0400, Peter Eisentraut wrote: > On 9/24/12 11:04 AM, Tom Lane wrote: > > Bruce Momjian <br...@momjian.us> writes: > >> Well, if you run that query on template0 in the old and new cluster, you > >> will see something different in the two of them. Could you have used > >> default in one and a non-dash in the other. Did we change the way we > >> canonicalize the locale between 9.1 and 9.2? > > > > IIRC, we didn't try to canonicalize locale names at all before 9.2. > > That initdb code you're quoting is of fairly recent vintage. > > initdb has changed POSIX to C with glibc at least since 8.3. The code > you're quoting is just a refactoring, AFAICT.
Frankly, I assumed the values assigned in pg_database for template0 were canonical. Tom is saying that canonicalization behavior changed between 9.1 to 9.2, and the user is reporting this. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers