Skip site navigation (1) Skip section navigation (2)

Need help

From: "Chris White (cjwhite)" <cjwhite(at)cisco(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Need help
Date: 2004-10-20 18:57:19
Message-ID: 200410201857.i9KIvGk2024151@sj-core-1.cisco.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2004-10-20 19:41:56
Subject: Re: Need help
Previous:From: Scott MarloweDate: 2004-10-20 15:45:20
Subject: Re: REVOKE not working...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group