pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adam Radlowski <adamr@informatyka.gdansk.pl>
To: Robin Iddon <robin@edesix.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: defining Your own sort order for already compiled PostgreSQL
Date: Thu, 25 May 2006 12:59:14 +0200
Message-ID: <44758E02.6020703@informatyka.gdansk.pl> (raw)
In-Reply-To: <4472C12F.8030700@edesix.com>
References: <4472B8ED.7020508@informatyka.gdansk.pl>
	<4472C12F.8030700@edesix.com>

Hello, Robin.
Thank You for Your answer.
What's going on:
Fox example, in old Paradox database system, It was possible to define 
Your own sort order. There was for example many ready-for-use sort 
definitions, like ASCII sort, DOS852,  DOS850. Every sort definition was 
in one file. When You renamed this file as "PARADOX.SOR", Paradox used 
it as default sort order (after restart of Paradox). It was possible to 
make Your own sort definition file.
Very simmilar is situation, when we at the first time run "initdb", but 
I don't know, how to make my own sort definition to use by "initdb". 
There is many read-to-use (like in Paradox) and I (after reading of 
docs) know, how to use them, but I want to define my own - not for 
example de_DE or en_US or pl_PL, but adam_ADAM ;-) and use it for "initdb".
Becouse Hakan's answers didn't help me, so I decided to workaround this 
problem, and - I suppose - with success (the idea looks good, but it is 
not realised to the end yet).
I don't write more about my "workaround idea", becouse it is a lot to 
write and I don't know, if it will be interesting for You (it was my 
problem, not Yours ;-) ).
Greetings from Gdynia
Adam

Robin Iddon wrote:

> Adam Radlowski wrote:
>
>> I can't find in the documentation, if it is possible to define our 
>> own sort order for already compiled PostgreSQL.
>> I need it, because the best for my now building application were be 
>> to build sort with normal LATIN2 sort order (for non alphanumeric 
>> chars compatible with ASCII sort order).
>> I saw in the "configure" file, that it is possible to define, what is 
>> alpha, what is number and so on, but it is inpossible to 
>> administrators of ready for use systems to - always recompile 
>> PostgreSQL for only one application.
>> With greetings
>> Adam
>
>
> Adam,
>
> I am not sure I completely understand what you're trying to do - 
> however, initdb can set the locale for a cluster including setting 
> specific locales for collation (which is what I think you want to 
> do).  I suppose you can invent your own locale if you need some 
> special sort order.
>
> These choices are frozen for the cluster (except that you can change 
> the encoding for a specific database within the cluster, but that 
> isn't going to do what you want, which is change the sort order).
>
> So, if you can re-run initdb then you can do what you want without 
> recompiling.
>
> See "man initdb" ...
>
> Hope this helps,
>
> Robin
>
>
>




view thread (6+ messages)

Message-ID: <44758E02.6020703@informatyka.gdansk.pl>
Permalink:  ../44758E02.6020703@informatyka.gdansk.pl/
Also on:    postgresql.org/message-id/44758E02.6020703@informatyka.gdansk.pl

 · 

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: adamr@informatyka.gdansk.pl, robin@edesix.com
  Subject: Re: defining Your own sort order for already compiled PostgreSQL
  In-Reply-To: <44758E02.6020703@informatyka.gdansk.pl>
  References: <4472B8ED.7020508@informatyka.gdansk.pl> <4472C12F.8030700@edesix.com> <44758E02.6020703@informatyka.gdansk.pl>

* 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