| From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | How to create database with default system locale is set to et_EE.UTF-8 |
| Date: | 2011-12-21 18:28:24 |
| Message-ID: | 9CA9DBDEA5D8474AB21DC01295E99A57@dell2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Xiaoning Xu | 2011-12-21 18:50:43 | [partition table] fetchall or fetchone function can not get the returning rows |
| Previous Message | Xiaoning Xu | 2011-12-21 18:24:29 | [partition table] fetchall or fetchone function can not get the returning rows |