Skip site navigation (1) Skip section navigation (2)

Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

From: WildWezyr <wildwezyr(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: milen(at)radev(dot)net
Subject: Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails
Date: 2010-01-25 09:50:41
Message-ID: 26fec1f6-4efd-4771-9bc5-20f1d797e7c6@b10g2000yqa.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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


Strange (?), but when I substituted equality to like in this line:

        select id into wordId from spb_word where word like w; --
was: ... word = w;

there is no error with polish locale.


  (WW)

In response to

pgsql-bugs by date

Next:From: Tim BunceDate: 2010-01-25 12:40:07
Subject: Re: Termination When Switching between PL/Perl and PL/PerlU
Previous:From: Euler Taveira de OliveiraDate: 2010-01-24 01:26:08
Subject: Re: BUG #5295: Function OUT parameters names and data types skewed with IN parameters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group