Re: lock problem when dont commit

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

Tom,

can you explain how that happens?

Dave

Tom Lane wrote:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2005-03-03 01:24:29 Re: lock problem when dont commit
Previous Message Tom Lane 2005-03-02 23:39:56 Re: lock problem when dont commit