아래처럼 하면 중복키 오류가 나는데 버그일까요?
ver: PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-20)
CREATE TABLE test
(
docno char(10) NOT NULL,
name char(10) NOT NULL,
CONSTRAINT pk_test PRIMARY KEY (docno, name)
)
WITHOUT OIDS;
ALTER TABLE test OWNER TO postgres;
insert into test values('00001', '홍길동');
insert into test values('00001', '장길산');
select * from test;
|