How to create database with default system locale is set to et_EE.UTF-8

Поиск
Список
Период
Сортировка
От Andrus
Тема How to create database with default system locale is set to et_EE.UTF-8
Дата
Msg-id 9CA9DBDEA5D8474AB21DC01295E99A57@dell2
обсуждение исходный текст
Ответы Re: How to create database with default system locale is set to et_EE.UTF-8
Список pgsql-general
Дерево обсуждения
In fresh Debian installation default system locale is set to et_EE.UTF-8 using
 
dpkg-reconfigure locales
 
Postgres is installed using
 
apt-get update
apt-get -t squeeze-backports install postgresql-9.1 postgresql-common postgresql-contrib
 
Trying to create database with et_EE.UTF-8 collation and character type returns error
 
---------------------------
pgAdmin III
---------------------------
An error has occurred:
 
ERROR:  new collation (et_EE.UTF-8) is incompatible with the collation of the template database (en_US.UTF-8)
HINT:  Use the same collation as in the template database, or use template0 as template.
 
How to create new database with et_EE.UTF-8 collation and character type ?
How to force Postgres installation to create template1 with et_EE.UTF-8 collation and character type ?
 
Andrus.
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: out of memory error with loading pg_dumpall
Следующее
От: Xiaoning Xu
Дата:
Сообщение: [partition table] fetchall or fetchone function can not get the returning rows