> 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.
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
Description: text/x-vcard (640 bytes)
In response to
- Need help at 2004-10-20 18:57:19 from Chris White (cjwhite)
pgsql-admin by date
|Next:||From: Chris Hoover||Date: 2004-10-20 20:17:14|
|Subject: question on postgresql.conf parameters (debug_print_xxx)|
|Previous:||From: Chris White (cjwhite)||Date: 2004-10-20 18:57:19|
|Subject: Need help|