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
Список
Дерево обсуждения
How to create database with default system locale is set to et_EE.UTF-8 "Andrus" <kobruleht2@hot.ee>
Re: How to create database with default system locale is set to et_EE.UTF-8 Adrian Klaver <adrian.klaver@gmail.com>
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 по дате отправления
От: Xiaoning Xu
Дата: