On Thu, 3 Oct 2002, Nikhil G. Daddikar wrote:
> While updating database (7.1.3) thro' JDBC I get a deadlock error :
>
> Exception Message: ERROR: Deadlock detected.
> See the lock(l) manual page for a possible cause.
>
> As far as i can see I am not doing anything which can cause such a thing, everything is pretty straight forward.
SometimesI get:
>
> Cannot insert a duplicate key into unique index db_security_desc_object_id_key
>
> I've looked at the code and these things shouldn't be happening, I am sure the mistake is mine but don't know how to
goabout debugging it. It happens only sometimes.
>
> I do have unique key constrains on the table.
>
> Any help will be appreciated.
Have you reset a sequence counter lately maybe? Or is the JDBC trying to
set the sequence number by itself instead of letting postgresql do it?