Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
Дата
Msg-id 2117.1347477844@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch  ("Henry C." <henka@cityweb.co.za>)
Ответы Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch  ("Henry C." <henka@cityweb.co.za>)
Список pgsql-general
Дерево обсуждения 
"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 по дате отправления:

Предыдущее
От: "Henry C."
Дата:
Сообщение: Re: 9.0 to 9.2 pg_upgrade pain due to collation mismatch
Следующее
От: Ben Chobot
Дата:
Сообщение: bgwriter and pg_locks