From: Honza Pazdziora <adelton@informatics.muni.cz>
To: Grega Bremec <grega.bremec@noviforum.si>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Refined LC_COLLATE or multiple database clusters?
Date: Wed, 9 Jun 2004 16:43:38 +0200
Message-ID: <20040609144338.GD29863@anxur.fi.muni.cz> (raw)
In-Reply-To: <20040609103303.GA4016@elbereth.noviforum.si>
References: <20040609103303.GA4016@elbereth.noviforum.si>
On Wed, Jun 09, 2004 at 12:33:03PM +0200, Grega Bremec wrote:
>
> Collate order for those databases, however, needs to be different. Obviously,
[...]
> Is it possible to do either of these things that could solve this problem
> adequately:
>
> - somehow manage to make one postmaster run on top of two separate
> database clusters that would each have a different collate ordering
> scheme
>
> - use some other method of initializing one database from a different
> template and taking with it LC_COLLATE setting (I suppose not, as
> the "${PGDATA}/global/" directory is global to the cluster)
>
> - use a patch that would add such functionality or upgrade to a version
> (even if release-candidate, beta is not really an option, i gather)
> of PostgreSQL that supported it
>
> - in absence of any other viable solution, change the global setting of
> the database cluster without having to dump/reinitdb/restore it
If you do not need the collating sequence to affect index operations,
you can use nls_string function to sort using
order by nls_string(column, 'sl_SI.utf-8')
where any locale can be specified in the runtime. The nls_string
result can also be used to compare strings in collating manner, however,
indexes will not be used in that case, which may or may not be a
problem for your usage.
The source of nls_string with installation instructions can be found
at
http://www.fi.muni.cz/~adelton/l10n/
--
------------------------------------------------------------------------
Honza Pazdziora | adelton@fi.muni.cz | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
Only self-confident people can be simple.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: adelton@informatics.muni.cz, grega.bremec@noviforum.si, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Refined LC_COLLATE or multiple database clusters?
In-Reply-To: <20040609144338.GD29863@anxur.fi.muni.cz>
References: <20040609103303.GA4016@elbereth.noviforum.si> <20040609144338.GD29863@anxur.fi.muni.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox