Re: Changing the concept of a DATABASE

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Susanne Ebrecht <susanne(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Changing the concept of a DATABASE
Date: 2012-05-22 16:03:43
Message-ID: CA+TgmoY=kYZ82RKfCWdABEwVMPeA+phKYfWpFNdLv6MN=X+SQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, May 22, 2012 at 12:00 PM, Susanne Ebrecht
<susanne(at)2ndquadrant(dot)com> wrote:
> Usually you want to set the collation once per language schema. E.g. schema
> russian gets Russian collation and schema British gets British collation and
> so on.
>
> CREATE SCHEMA foo LC_COLLATE bar isn't supported so you went up a level and
> do it by creating a database.
>
> I would like to get default collation per schema / table in 9.2 or 9.3 but
> that is my personal
> wish,

Interesting idea. Sort of like ALTER DEFAULT PRIVILEGES.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-05-22 16:11:52 Re: Readme of Buffer Management seems to have wrong sentence
Previous Message Thom Brown 2012-05-22 16:03:06 Re: Per-Database Roles