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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group