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 B13DB32A15D for ; Wed, 20 Oct 2004 20:42:16 +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 07678-09 for ; Wed, 20 Oct 2004 19:42:02 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id E486832A90F for ; Wed, 20 Oct 2004 20:42:02 +0100 (BST) Received: from [192.168.1.51] (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i9KJg1D17367; Wed, 20 Oct 2004 12:42:01 -0700 Message-ID: <4176BF84.3040307@commandprompt.com> Date: Wed, 20 Oct 2004 12:41:56 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: cjwhite@cisco.com Cc: pgsql-admin@postgresql.org Subject: Re: Need help References: <200410201857.i9KIvGk2024151@sj-core-1.cisco.com> In-Reply-To: <200410201857.i9KIvGk2024151@sj-core-1.cisco.com> Content-Type: multipart/mixed; boundary="------------060109060807030807040802" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.5 tagged_above=0.0 required=5.0 tests=RAZOR2_CF_RANGE_11_50, RAZOR2_CHECK X-Spam-Level: * X-Archive-Number: 200410/261 X-Sequence-Number: 15254 This is a multi-part message in MIME format. --------------060109060807030807040802 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit > 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 --------------060109060807030807040802 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard --------------060109060807030807040802--