getting this error when trying to add a new issue status:

warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key violates unique constraint "project_issue_state_pkey" in /Users/hunmonk/Sites/drupal/drupal-5/includes/database.pgsql.inc on line 125.

CommentFileSizeAuthor
#1 project_issue_postgres_install.patch1.43 KBhunmonk

Comments

hunmonk’s picture

hunmonk commented
Assigned: Unassigned » hunmonk
Status: Active » Needs review
StatusFileSize
new project_issue_postgres_install.patch1.43 KB

i think the code comment in the patch says it all. tested and working on a fresh install. upgrade also tested and working. i'll roll patches for 4.7 once this hits RTBC

dww’s picture

dww
we/he/they
commented
Status: Needs review » Needs work

Let's rename that update to 5000 and start clean. ;) Apologies for the 3 digit numbering on the earlier updates -- that was from before the conventions were finalized. Otherwise, this is RTBC. Just commit, don't bother re-rolling, etc.

Thanks!
-Derek

hunmonk’s picture

hunmonk commented
Status: Needs work » Fixed

fixed in HEAD, 4.7.x-1.x, 4.7.x-2.x.

i used update 5000 for HEAD, and update 3 for the other branches.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)