Lists: | pgsql-bugs |
---|
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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";