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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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--
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-03-28 16:22:20 | Re: is postgresql 8 is realy mature |
Previous Message | Bruno Wolff III | 2005-03-28 15:57:15 | Re: is postgresql 8 is realy mature |
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey Slynko | 2005-03-28 16:28:04 | Re: [PATCHES] Patch for database locale settings |
Previous Message | Tom Lane | 2005-03-28 15:54:16 | Re: [PATCHES] Patch for database locale settings |