Re: per-database locale: createdb switches - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: per-database locale: createdb switches
Date
Msg-id 496C6F48.3080206@enterprisedb.com
Whole thread Raw
In response to Re: per-database locale: createdb switches  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: per-database locale: createdb switches  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut wrote:
> Which raises yet another question, why CTYPE and COLLATE have to be 
> hardcoded settings and catalog columns instead of being stored in 
> datconfig as database-startup-only settings?

Because changing CTYPE or COLLATE in an existing database would render 
indexes broken.

Perhaps we could've put them in datconfig, and forbidden changing them 
after CREATE DATABASE. Then again, encoding is a similar setting too, 
and that's stored in a catalog column.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Recovery Test Framework
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Proposal: new border setting in psql