Postgres Pro
Downloads
Home   >   mailing lists

How to create database with default system locale is set to et_EE.UTF-8 - Mailing list pgsql-general

From Andrus
Subject How to create database with default system locale is set to et_EE.UTF-8
Date
Msg-id 9CA9DBDEA5D8474AB21DC01295E99A57@dell2
Whole thread Raw
Responses Re: How to create database with default system locale is set to et_EE.UTF-8
List pgsql-general
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: out of memory error with loading pg_dumpall
Next
From: Xiaoning Xu
Date:
Subject: [partition table] fetchall or fetchone function can not get the returning rows