Home > mailing lists

Need help - Mailing list pgsql-admin

From	Chris White (cjwhite)
Subject	Need help
Date	October 20, 2004 22:57:33
Msg-id	200410201857.i9KIvGk2024151@sj-core-1.cisco.com Whole thread Raw
Responses	Re: Need help ("Joshua D. Drake" <jd@commandprompt.com>) Re: Need help ("Scott Marlowe" <smarlowe@qwest.net>)
List	pgsql-admin

I am running 7.4.2 and I am seeing a strange error. I am using jdbc to update a table with the following statement:

update vm_message set usecount=4 where messsage id='1234567';

this statements generates a PSQLException with the following message:

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?

Chris White

From: Christian Fowler
Date: 20 October 2004, 19:45:29
Subject: Re: large dumps won't restore

From: "Joshua D. Drake"
Date: 20 October 2004, 23:42:20
Subject: Re: Need help