C collation and Template 1 - Mailing list pgsql-admin

From Kasia Tuszynska
Subject C collation and Template 1
Date
Msg-id 232B5217AD58584C87019E8933556D1102DE1837FB@redmx2.esri.com
Whole thread Raw
List 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

 

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: How to change all owners on all objects in a schema
Next
From: "Kevin Grittner"
Date:
Subject: Re: How to change all owners on all objects in a schema