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

Re: Patch for database locale settings

From: Alexey Slynko <slynko(at)tronet(dot)ru>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: Patch for database locale settings
Date: 2005-03-28 16:04:18
Message-ID: 20050328195651.N22875@witch.tronet.ru (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

--0-1348485674-1112025858=:22875
Content-Type: TEXT/PLAIN; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 8BIT

> 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.
I havn't see any shared indices, that uses any variable collation, like text 
indices. All shared indexed columns have integer and name type. As I understand, 
all this types have fixed collation. Or I've missed something ?

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

 				Alexey Slynko
 				E-mail: slynko(at)tronet(dot)ru

--0-1348485674-1112025858=:22875--

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-03-28 16:22:20
Subject: Re: is postgresql 8 is realy mature
Previous:From: Bruno Wolff IIIDate: 2005-03-28 15:57:15
Subject: Re: is postgresql 8 is realy mature

pgsql-patches by date

Next:From: Alexey SlynkoDate: 2005-03-28 16:28:04
Subject: Re: [PATCHES] Patch for database locale settings
Previous:From: Tom LaneDate: 2005-03-28 15:54:16
Subject: Re: [PATCHES] Patch for database locale settings

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