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:[EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 12:42 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
