Re: Need help

That doesn't help me because this is running in an embedded system that
should have little or no db admin. Anybody suggest what version I should be
running?

Chris

-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Wednesday, October 20, 2004 12:42 PM
To: cjwhite@cisco.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Need help

> 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@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL