Table "crawlsite"
Attribute | Type | Modifier
----------------+-----------------------+-------------------------------------------
site_id | numeric(5,0) | not null default nextval('SITESEQ'::text)
site_kind | numeric(5,0) | not null
site_cate | numeric(5,0) | not null
site_abbr | character varying(30) | not null
site_url | character varying(60) | not null
site_name | character varying(60) | not null
site_crawlday | numeric(2,0) | not null
site_starthour | numeric(2,0) | not null
site_endhour | numeric(2,0) | not null
site_interval | numeric(3,0) | not null
site_language | numeric(5,0) | not null
site_quit | numeric(2,0) | not null
site_charset | numeric(5,0) | not null
Index: crawlsite_pkey
테이블이 이런식으로 있을때
insert into crawlsite values(NEXTVAL('siteseq'), 1, 0, 'securityfocus', 'securityfocus.com', 'securityfocus',9,5,23,60,1001,1,3001);
이렇게 해주면
ERROR: Cannot insert a duplicate key into unique index crawlsite_pkey
이런 에러가 나는군요 site_id 를 자동 증가 시키고 싶은에 방법이 없을까요?
답변 부탁드립니다
|