Re: Default Locale in initdb - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Default Locale in initdb
Date
Msg-id 40BE7DF0.6030309@familyhealth.com.au
Whole thread Raw
In response to Re: Default Locale in initdb  (Paul Ramsey <pramsey@refractions.net>)
Responses Re: Default Locale in initdb
List pgsql-hackers
> When this new behavior was introduced, and I migrated our databases to 
> the new PgSQL version (dump/restore), the locale of all my databases 
> were silently changed from C to US_en. This broke one application in a 
> very subtle way because of slightly different sort behavior in the 
> different locale. Tracking it down was quite tricky.
> 
> PgSQL was just a little too helpful in this case.

Seems pretty nasty thing to do.  I would so vote for making -E and -W 
and --locate required flags to initdb.  Oh the amount of time I've spent 
with people in IRC..

Chris



pgsql-hackers by date:

Previous
From: Jonathan Gardner
Date:
Subject: Re: process num.
Next
From: Bruce Momjian
Date:
Subject: Re: Default Locale in initdb