Re: Need help - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Need help
Date
Msg-id 4176BF84.3040307@commandprompt.com
Whole thread Raw
In response to Need help  ("Chris White (cjwhite)" <cjwhite@cisco.com>)
Responses Re: Need help
List pgsql-admin
> 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

Attachment

pgsql-admin by date:

Previous
From: "Chris White (cjwhite)"
Date:
Subject: Need help
Next
From: "Chris Hoover"
Date:
Subject: question on postgresql.conf parameters (debug_print_xxx)