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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "WildWezyr" <wi(dot)ld(dot)we(dot)zy(dot)r(at)gmail(dot)com>
Cc: 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-19 22:23:15
Message-ID: 21124.1263939795@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"WildWezyr" <wi(dot)ld(dot)we(dot)zy(dot)r(at)gmail(dot)com> writes:
> If I eliminate polish national chars from function spb_getWord i.e. it will
> generate words with plain ascii chars there is no error and everything works
> fine.

What that sounds like is a locale/encoding conflict.  Postgres depends
on strcoll() or local equivalent to produce consistent sort results,
and sometimes if strcoll is presented with data that it thinks is
invalidly encoded, it doesn't behave sanely.

What locale setting and database encoding are you using?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2010-01-20 03:44:00
Subject: Re: BUG #5291: Password change restrictions
Previous:From: Chris ArensdorfDate: 2010-01-19 21:31:46
Subject: BUG #5291: Password change restrictions

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