X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4DFD932A29B for ; Wed, 20 Oct 2004 21:31:50 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28750-03 for ; Wed, 20 Oct 2004 20:31:42 +0000 (GMT) Received: from sj-iport-1.cisco.com (sj-iport-1-in.cisco.com [171.71.176.70]) by svr1.postgresql.org (Postfix) with ESMTP id C2AA532A2E3 for ; Wed, 20 Oct 2004 21:31:42 +0100 (BST) Received: from sj-core-5.cisco.com (171.71.177.238) by sj-iport-1.cisco.com with ESMTP; 20 Oct 2004 13:41:55 -0700 X-BrightmailFiltered: true Received: from cjwhitew2k02 (dhcp-128-107-147-121.cisco.com [128.107.147.121]) by sj-core-5.cisco.com (8.12.10/8.12.6) with ESMTP id i9KKVeOE002091; Wed, 20 Oct 2004 13:31:40 -0700 (PDT) Message-Id: <200410202031.i9KKVeOE002091@sj-core-5.cisco.com> Reply-To: From: "Chris White (cjwhite)" To: "'Joshua D. Drake'" Cc: Subject: Re: Need help Date: Wed, 20 Oct 2004 13:31:37 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <4176BF84.3040307@commandprompt.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Thread-Index: AcS23O5ITTXYESvCRBWOReML+If99QABqe9w X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/263 X-Sequence-Number: 15256 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