pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.



view thread (3+ messages)

Message-ID: <20040609144338.GD29863@anxur.fi.muni.cz>
Permalink:  ../20040609144338.GD29863@anxur.fi.muni.cz/
Also on:    postgresql.org/message-id/20040609144338.GD29863@anxur.fi.muni.cz

 · 

reply

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