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

Reply via email to