Skip site navigation (1) Skip section navigation (2)

Re: Need help

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: cjwhite(at)cisco(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Need help
Date: 2004-10-20 19:41:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
> ERROR: duplicate key violates unique constraint "vm_message_pkey"
> I don't understand why I am getting this message because the primary key 
> for table vm_message is messageid and this is not being changed
> Any body have any ideas?

7.4.2 is know to have index issues. Try reindexing the primary key and 
executing the query again.


Joshua D. Drake

> Chris White

Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com -
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment: jd.vcf
Description: text/x-vcard (640 bytes)

In response to

  • Need help at 2004-10-20 18:57:19 from Chris White (cjwhite)


  • Re: Need help at 2004-10-20 20:31:37 from Chris White (cjwhite)

pgsql-admin by date

Next:From: Chris HooverDate: 2004-10-20 20:17:14
Subject: question on postgresql.conf parameters (debug_print_xxx)
Previous:From: Chris White (cjwhite)Date: 2004-10-20 18:57:19
Subject: Need help

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group