Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] Patch for database locale settings

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Alexey Slynko <slynko(at)tronet(dot)ru>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCHES] Patch for database locale settings
Date: 2005-03-28 14:48:30
Message-ID: 20050328144830.GC3574@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Mon, Mar 28, 2005 at 12:16:42PM +0400, Alexey Slynko wrote:

> this patch allow to use database locale settings. It remove cluster locale 
> settings, and append LCCTYPE and
> LCCOLLATE items to  CREATE DATABASE syntax.
> 
> Any considerations ?

The problem with this is what happens to indexes on shared relations.
If you change the collation, they are no longer valid.  And you can't
just reindex them, because then they would no longer be valid for other
databases.

Maybe it would work if we forced indexes on shared relations to be
scanned using a fixed collation.

Not sure about the ctype part ...

-- 
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Los románticos son seres que mueren de deseos de vida"

In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2005-03-28 15:07:08
Subject: Re: minor windows & cygwin regression failures on stable
Previous:From: Alvaro HerreraDate: 2005-03-28 14:43:35
Subject: Re: Executing Anonymous Blocks

pgsql-patches by date

Next:From: Tom LaneDate: 2005-03-28 15:54:16
Subject: Re: [PATCHES] Patch for database locale settings
Previous:From: Robert TreatDate: 2005-03-28 13:42:47
Subject: Update to download info in install docs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group