Re: error: duplicate key

On Wed, Jun 17, 2009 at 10:51 AM, Marc Fromm<Marc(dot)Fromm(at)wwu(dot)edu> wrote:
> 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.

What does

select * from classification_guide_cat_id_seq;

say? Also, what's the DDL for creating this table? You can get it
with pg_dump -s -t tablename