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

BUG #4463: unique constraint error

From: "zhengzhong_zhou" <zhouzhengzhong_1(at)163(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4463: unique constraint error
Date: 2008-10-10 07:59:21
Message-ID: 200810100759.m9A7xLkL030200@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4463
Logged by:          zhengzhong_zhou
Email address:      zhouzhengzhong_1(at)163(dot)com
PostgreSQL version: 8.3.4
Operating system:   centos 5.2 x64
Description:        unique constraint error
Details: 

i create a table : 
tbl_test (col1 varchar(100),col2 smallint,col3 varchar(10));
constraint : uk_col1_col2 (col1,col2)

data : 
 col1 | col2 | col3 
------+------+------
 yes  |    6 | okk
 yes  |    7 | okk
 yes  |    8 | okk
(3 rows)

bugs : 
db_oversea=> update tbl_test set col2=(col2+1) where col3='okk';
ERROR:  duplicate key value violates unique constraint "uk_col1_col2";

pgsql-bugs by date

Next:From: Tony MarstonDate: 2008-10-10 09:47:59
Subject: BUG #4465: GROUP BY is not to SQL standard
Previous:From: Peter EisentrautDate: 2008-10-09 16:09:10
Subject: Re: Locale (unsupported) bug. uk_UA.KOI8-U

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