Christopher Kings-Lynne wrote: > > 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..
What about folks who don't use locales? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]