From: | Robin Iddon <robin(at)edesix(dot)com> |
---|---|
To: | Adam Radlowski <adamr(at)informatyka(dot)gdansk(dot)pl> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: defining Your own sort order for already compiled PostgreSQL |
Date: | 2006-05-23 08:00:47 |
Message-ID: | 4472C12F.8030700@edesix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hakan Kocaman | 2006-05-23 08:14:27 | Re: defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters) |
Previous Message | Adam Radlowski | 2006-05-23 07:25:33 | defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters) |