Re: Need help

From: "Chris White (cjwhite)" <cjwhite(at)cisco(dot)com>
To: "'Joshua D(dot) Drake'" <jd(at)commandprompt(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Need help
Date: 2004-10-20 20:31:37
Message-ID: 200410202031.i9KKVeOE002091@sj-core-5.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)commandprompt(dot)com]
Sent: Wednesday, October 20, 2004 12:42 PM
To: cjwhite(at)cisco(dot)com
Cc: pgsql-admin(at)postgresql(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2004-10-20 20:41:29 Re: Need help
Previous Message Chris Hoover 2004-10-20 20:17:14 question on postgresql.conf parameters (debug_print_xxx)