From: Chris White (cjwhite) <cjwhite@cisco.com>
To: 'Joshua D. Drake' <jd@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Need help
Date: Wed, 20 Oct 2004 13:31:37 -0700
Message-ID: <200410202031.i9KKVeOE002091@sj-core-5.cisco.com> (raw)
In-Reply-To: <4176BF84.3040307@commandprompt.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cjwhite@cisco.com, jd@commandprompt.com
Subject: Re: Need help
In-Reply-To: <200410202031.i9KKVeOE002091@sj-core-5.cisco.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox