From: | "Milen A(dot) Radev" <milen(at)radev(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails |
Date: | 2010-01-22 15:22:12 |
Message-ID: | 4B59C2A4.9080104@radev.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
WildWezyr написа:
> On Jan 21, 6:17 pm, mi(dot)(dot)(dot)(at)radev(dot)net ("Milen A. Radev") wrote:
>> [...]
>>
>> For the test I changed all regional settings to "Polish (Poland)",
>> restarted the machine, created a new cluster and a new database (using
>> the commands from the last mail from Heikki).
>>
>> A side-note: tested exactly the same function but on "Bulgarian
>> (Bulgaria)" system locale and cluster and database created with
>> "Bulgarian_Bulgaria.1251" locale - no errors.
>>
>> --
>> Milen A. Radev
>>
>
> No error for Bulgarian locale might be related to absence of Bulgarian
> national characters in words generated by my test code. I've put only
> polish characters (ąćęłńóśźż) - and it fails with polish collation,
> but after removing polish characters - i get no error with polish
> collation. I thing it may behave exactly the same for Bulgarian - to
> produce errors you must modify letters to include Bulgarian chars
> (line: letters varchar(255) := 'ąćęłńóśźżjklmnopqrstuvwxyz'; --<--
> put these letters here).
>
> Have you tried this?
>
Yes, actually I tried it yesterday but just to be sure I tried it again
today - no errors:
....
NOTICE: i = 9999800
NOTICE: i = 9999900
NOTICE: i = 10000000
Total query runtime: 2231947 ms.
1 row retrieved.
The "letters" variable used in the test (in case you have the time to
try it yourself):
letters varchar(255) := 'юяьъщшчцфjklmnopqrstuvwxyz';
And the database definition:
CREATE DATABASE spb
WITH OWNER = postgres
ENCODING = 'UTF8'
LC_COLLATE = 'Bulgarian_Bulgaria.1251'
LC_CTYPE = 'Bulgarian_Bulgaria.1251'
CONNECTION LIMIT = -1;
The system locale is "Bulgarian (Bulgaria)".
--
Milen A. Radev
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Patin | 2010-01-22 15:26:55 | BUG #5295: Function OUT parameters names and data types skewed with IN parameters |
Previous Message | Greg Stark | 2010-01-22 14:06:13 | Re: BUG #5294: Sorts on more than just the order-by clause |