|
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.
|
