Chris White (cjwhite) wrote:
> 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?
7.4.5.
Sincerely,
Joshua D. Drake
>
> 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
--
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