pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedCreating locales.
3+ messages / 3 participants
[nested] [flat]
* Creating locales.
@ 2000-12-27 17:18 Tim Uckun <tim@diligence.com>
0 siblings, 2 replies; 3+ messages in thread
From: Tim Uckun @ 2000-12-27 17:18 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org
I have been searching without luck on a howto on how to create locales for
postgres. Could somebody please point me in the general direction? Thanks.
:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/ Americas Background
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered
the risks of a bad hire.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Creating locales.
@ 2000-12-30 09:34 Oleg Bartunov <oleg@sai.msu.su>
parent: Tim Uckun <tim@diligence.com>
1 sibling, 0 replies; 3+ messages in thread
From: Oleg Bartunov @ 2000-12-30 09:34 UTC (permalink / raw)
To: Tim Uckun <tim@diligence.com>; +Cc: pgsql-hackers@postgresql.org
You do not need create locale specially for postgres. Postgres uses
system locale. You could look at /usr/share/locale
regards,
Oleg
On Wed, 27 Dec 2000, Tim Uckun wrote:
> Date: Wed, 27 Dec 2000 10:18:01 -0700
> From: Tim Uckun <tim@diligence.com>
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] Creating locales.
>
> I have been searching without luck on a howto on how to create locales for
> postgres. Could somebody please point me in the general direction? Thanks.
>
> :wq
> Tim Uckun
> Due Diligence Inc. http://www.diligence.com/ Americas Background
> Investigation Expert.
> If your company isn't doing background checks, maybe you haven't considered
> the risks of a bad hire.
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Creating locales.
@ 2000-12-30 11:43 Hannu Krosing <hannu@tm.ee>
parent: Tim Uckun <tim@diligence.com>
1 sibling, 0 replies; 3+ messages in thread
From: Hannu Krosing @ 2000-12-30 11:43 UTC (permalink / raw)
To: Tim Uckun <tim@diligence.com>; +Cc: pgsql-hackers@postgresql.org, Oleg Bartunov <oleg@sai.msu.su>
Tim Uckun wrote:
>
> I have been searching without luck on a howto on how to create locales for
> postgres. Could somebody please point me in the general direction? Thanks.
>
PostgreSQL uses system locales (even to the extent that I was unable to
get
it use any other locale by setting LC_* variables in
/etc/init.d/rc.d/postgres)
I did have to modify my locale (et_EE) to _not_ group \xff (ÿaut;)
with
other y-s but to sort it after all other "standard" chars to work
properly
with LIKE optimisations. Perhaps the right approach would be to leave
\xff
alone and to choose some character in the 128-159 range for
bigger-than-any-other-char but as \xff is not used in estonian i was
able
to do away with just moving it.
OTOH, it may be a good idea to start a repository for locales that are
specifilally modified to work well with postgres.
We may want to move the locale stuff inside the backend someday as
mandated
by SQL standards and then some work would be already done.
--------
Hannu
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-12-30 11:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-27 17:18 Creating locales. Tim Uckun <tim@diligence.com>
2000-12-30 09:34 ` Oleg Bartunov <oleg@sai.msu.su>
2000-12-30 11:43 ` Hannu Krosing <hannu@tm.ee>
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