Postgres Pro
Downloads
Home   >   mailing lists

Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch - Mailing list pgsql-general

From Tom Lane
Subject Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
Date
Msg-id 2117.1347477844@sss.pgh.pa.us
Whole thread Raw
In response to Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch  ("Henry C." <henka@cityweb.co.za>)
Responses Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
List pgsql-general
Tree view 
"Henry C." <henka@cityweb.co.za> writes:
> 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.

Yeah, that should do it.

            regards, tom lane

pgsql-general by date:

Previous
From: "Henry C."
Date:
Subject: Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
Next
From: Ben Chobot
Date:
Subject: bgwriter and pg_locks