Re: [GENERAL] false unique constraint error...for me

2007-02-23 Thread djé djé
gsql-general@postgresql.org Subject: Re: [GENERAL] false unique constraint error...for me Date: Fri, 23 Feb 2007 10:19:07 -0500 =?iso-8859-1?B?ZGrpIGRq6Q==?= <[EMAIL PROTECTED]> writes: > I get the error : ERROR: duplicate key violates unique constraint > "unique_barcode12

Re: [GENERAL] false unique constraint error...for me

2007-02-23 Thread Tom Lane
=?iso-8859-1?B?ZGrpIGRq6Q==?= <[EMAIL PROTECTED]> writes: > I get the error : ERROR: duplicate key violates unique constraint > "unique_barcode128" > But the string returned by text2code128('AB28662097') and > text2code128('AB28662098') are different!!!, i.e., respectively ÌABÇ and ÌABÇ

[GENERAL] false unique constraint error...for me

2007-02-23 Thread djé djé
Hi all, I don't know if it's a bug or not...but things are quite strange for me. My problem comes from a unique constraint violation whereas tha data I try to insert in my table are different (at least for me). My database is encoded using SQL_ASCII, postgresql 7.4.8 on a Red Hat Advanced Server