From: | Sungchul Park <scpark(at)gen128(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | duplicate key ? (fwd) |
Date: | 2000-10-21 04:25:58 |
Message-ID: | Pine.LNX.4.10.10010211315210.715-100000@scpark.gen128.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I didn't get any answer about my question posted yesterday.
please share your knowledge and wisdom with me, a poor s/w engineer.
---------- Forwarded message ----------
Date: Fri, 20 Oct 2000 21:30:27 +0900 (KST)
From: Sungchul Park <scpark(at)gen128(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] duplicate key ?
Please check following...
Fo2Me=# drop table dirinfo;
DROP
Fo2Me=# CREATE TABLE dirinfo(
Fo2Me(# code VARCHAR(8) PRIMARY KEY,
Fo2Me(# level SMALLINT NOT NULL,
Fo2Me(# name TEXT NOT NULL,
Fo2Me(# count SMALLINT NOT NULL DEFAULT 0
Fo2Me(# );
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'dirinfo_pkey'
for table 'dirinfo'
CREATE
Fo2Me=# INSERT INTO dirinfo (code, level, name) VALUES('hbcol', 1, 'abc');
INSERT 63411 1
Fo2Me=# INSERT INTO dirinfo (code, level, name) VALUES('hbcrf', 1, 'zzz');
ERROR: Cannot insert a duplicate key into unique index dirinfo_pkey
I couldn't understand this error message. What's wrong?
The version of postgresql is 7.0.2 and the database created with EUC_KR encoding.
------
Park, Sungchul / mailto:scpark(at)gen128(dot)com
gen128, inc. - The internet company powered by open source.
http://www.gen128.com / Voice : +82-2-3017-0128 / Fax : +82-2-3017-1128
238-9 poi kangnam, #601 poongjoen bldg., Seoul 135-250, Republic of Korea
From | Date | Subject | |
---|---|---|---|
Next Message | KuroiNeko | 2000-10-21 04:46:52 | Re: duplicate key ? (fwd) |
Previous Message | Ashley Clark | 2000-10-21 04:24:15 | trigger/cached updates question |