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 |