error: duplicate key

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux