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?
pgsql-admin by date
|Next:||From: Joshua D. Drake||Date: 2004-10-20 19:41:56|
|Subject: Re: Need help|
|Previous:||From: Scott Marlowe||Date: 2004-10-20 15:45:20|
|Subject: Re: REVOKE not working...|