Hi, i think this explains, what you ment: http://www.linuxshare.ru/postgresql/manual/creating-cluster.html http://www.linuxshare.ru/postgresql/manual/charset.html#LOCALE So you don't need to set the Locale-Settings on compile-time, but on initdb-time. Also check if this applies to your kinds of query, because with a non-C Locale you need to define the indices with a different operator- class to use the indices with like-comparisons. See http://www.postgresql.org/docs/8.1/static/indexes-opclass.html for more details. Best regards Hakan Kocaman Software-Development digame.de GmbH Richard-Byrd-Str. 4-8 50829 Köln Tel.: +49 (0) 221 59 68 88 31 Fax: +49 (0) 221 59 68 88 98 Email: hakan.kocaman@xxxxxxxxx > -----Original Message----- > From: pgsql-admin-owner@xxxxxxxxxxxxxx > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Adam Radlowski > Sent: Tuesday, May 23, 2006 9:26 AM > To: pgsql-admin@xxxxxxxxxxxxxx > Subject: [ADMIN] defining Your own sort order for already > compiled PostgreSQL (because PSQL sort orders are incopatible > with ASCII sort order for non -alpha characters) > > > 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx > so that your > message can get through to the mailing list cleanly >
