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