error: duplicate key - Mailing list pgsql-admin

From Marc Fromm
Subject error: duplicate key
Date
Msg-id B0D7C0A3F35FE144A70312D086CBCA9B038513CF80@ExchMailbox2.univ.dir.wwu.edu
Whole thread Raw
Responses Re: error: duplicate key  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin

I am receiving this error when I try to add new records:

 

INSERT INTO "public"."classification_guide_cats" ("id", "cat_title") VALUES (nextval(('"classification_guide_cat_id_seq"'::text)::regclass), 'temp')

SQL error:

ERROR:  duplicate key violates unique constraint "classification_guide_cats_pkey"

 

id is a primary key nextval(('"classification_guide_job_id_seq"'::text)::regclass)

 

Could the primary key count have been reset so that it is starting at 1 again? The primary key id is up to 128.

 

Thanks

 

 

Marc

 

pgsql-admin by date:

Previous
From: "Patryk Sosinski"
Date:
Subject: Postgre Service Cant Start
Next
From: Scott Marlowe
Date:
Subject: Re: error: duplicate key