Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch

From: "Henry C(dot)" <henka(at)cityweb(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
Date: 2012-09-12 19:05:22
Message-ID: 39ee482468252fadcac2df142db4d022.squirrel@support.metroweb.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> "C" is the official name of that locale. Not sure how you got it to say
> "POSIX" ... maybe we didn't have normalization of the locale name back
> then?
>
> Anyway, simplest fix seems to be to update the 9.0 installation's
> pg_database to say "C" in those entries.

Never ceases to amaze me where you guys find the time to respond so
quickly on this list...

Anyway, thanks for the feedback. Ok, so it's simply a case of:

update pg_database set datcollate='C', datctype='C';

Correct? Mine are all POSIX, so no where clause needed.

Thanks

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-09-12 19:24:04 Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
Previous Message Tom Lane 2012-09-12 18:31:19 Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch