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 를 자동 증가 시키고 싶은에 방법이 없을까요?

답변 부탁드립니다