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: 4176BF84.3040307@commandprompt.com (view raw or flat)
Thread:
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.

Sincerely,

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 - http://www.commandprompt.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)

Responses

  • 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-2014 The PostgreSQL Global Development Group