Re: lock problem when dont commit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pg(at)fastcrypt(dot)com
Cc: Mican Bican <mican58(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: lock problem when dont commit
Date: 2005-03-02 23:39:56
Message-ID: 15017.1109806796@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> There must be something else going on here. There is no lock on an
> insert. Are you doing a select for update ?

Maybe a conflict on referenced foreign-key rows?

regards, tom lane

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-03-03 00:34:43 Re: lock problem when dont commit
Previous Message Dave Cramer 2005-03-02 23:24:47 Re: lock problem when dont commit