| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | cjwhite(at)cisco(dot)com |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Need help |
| Date: | 2004-10-20 19:41:56 |
| Message-ID: | 4176BF84.3040307@commandprompt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
| Attachment | Content-Type | Size |
|---|---|---|
| jd.vcf | text/x-vcard | 640 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Hoover | 2004-10-20 20:17:14 | question on postgresql.conf parameters (debug_print_xxx) |
| Previous Message | Chris White (cjwhite) | 2004-10-20 18:57:19 | Need help |