C collation and Template 1

From: Kasia Tuszynska <ktuszynska(at)esri(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: C collation and Template 1
Date: 2011-06-23 17:47:25
Message-ID: 232B5217AD58584C87019E8933556D1102DE1837FB@redmx2.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I tried to create the following database:

CREATE DATABASE testing
WITH ENCODING='UTF8'
OWNER=postgres
TEMPLATE=template1
LC_COLLATE='C'
LC_CTYPE='C'
CONNECTION LIMIT=-1;

And received the following error in pgAdminIII:

"An error has occurred:
ERROR: new collation (C) is incompatible with the collation of the template database (English_United States.1252)
Hint: Use the same collation as the template database, or use template 0 as template."

To my understanding Template 1 allows the postgres user to perform housecleaning/administrative tasks such as Vacuum Analyze, Template 0 does not contain those privileges.

My ultimate goal would be to use the C collation and Template 1.
Why are the two incompatible?

Thank you,
Sincerely,
Kasia

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-06-23 20:39:12 Re: How to change all owners on all objects in a schema
Previous Message Campbell, Lance 2011-06-23 15:59:06 How to change all owners on all objects in a schema