Re: Major Problem with locale

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "postgres" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Major Problem with locale
Date: 2002-10-01 14:40:10
Message-ID: 002b01c26958$7189f3e0$aa0f5ac2@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

what i should patch ?
postgres files or maybe something else ?

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
Cc: "postgres" <pgsql-general(at)postgresql(dot)org>
Sent: Monday, September 30, 2002 8:44 PM
Subject: Re: [GENERAL] Major Problem with locale

> "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> writes:
> > what was diffrent then ver 7.1.3 was that initdb (7.2.2) didnt answered
me
> > with the message that locale reduce speed.
>
> 7.2's initdb is a bit broken in this respect --- you won't see that
> message unless you use -d (in which case you'll have to dig through
> about 4meg worth of debug chatter :-(). This is repaired again for
> 7.3, though.
>
> > how can i know that my db using specific locale ?
>
> See contrib/pg_controldata if you want to be sure.
>
> > what cab be the couse that "l_name ~* '[[:<:]](xyz)[[:>:]]'" dont work
for
> > some of the hebrew characters ?
>
> Perhaps the regex support is missing info about this particular locale.
> Feel free to send in a patch, if so ...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-10-01 15:13:31 Re: current_timestamp after queries
Previous Message Jean-Christian Imbeault 2002-10-01 14:28:10 string parsing