X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E11759F9EEB for ; Tue, 23 May 2006 05:00:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 26692-01 for ; Tue, 23 May 2006 05:00:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from astro.systems.pipex.net (astro.systems.pipex.net [62.241.163.6]) by postgresql.org (Postfix) with ESMTP id 52A999FA2BC for ; Tue, 23 May 2006 05:00:43 -0300 (ADT) Received: from flange.edesix.com (81-86-64-114.dsl.pipex.com [81.86.64.114]) by astro.systems.pipex.net (Postfix) with ESMTP id DB86EE0004FA; Tue, 23 May 2006 09:00:35 +0100 (BST) Received: from host81-153-246-73.range81-153.btcentralplus.com ([81.153.246.73] helo=[192.168.101.208]) by flange.edesix.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.60) (envelope-from ) id 1FiRog-0002XS-W0; Tue, 23 May 2006 09:00:35 +0100 Message-ID: <4472C12F.8030700@edesix.com> Date: Tue, 23 May 2006 09:00:47 +0100 From: Robin Iddon User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: Adam Radlowski CC: pgsql-admin@postgresql.org Subject: Re: defining Your own sort order for already compiled PostgreSQL References: <4472B8ED.7020508@informatyka.gdansk.pl> In-Reply-To: <4472B8ED.7020508@informatyka.gdansk.pl> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/308 X-Sequence-Number: 21840 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