Re: lock problem when dont commit - Mailing list pgsql-jdbc

From Mican Bican
Subject Re: lock problem when dont commit
Date
Msg-id 4226C7C4.6020002@gmail.com
Whole thread Raw
In response to Re: lock problem when dont commit  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: lock problem when dont commit
List pgsql-jdbc
Tom Lane schrieb:

>Dave Cramer <pg@fastcrypt.com> writes:
>
>
>>Tom Lane wrote:
>>
>>
>>>Maybe a conflict on referenced foreign-key rows?
>>>
>>>
>
>
>
>>can you explain how that happens?
>>
>>
>
>When you insert or update a row in a table that has an FK reference,
>it takes out a row-level lock on the referenced row in the master table.
>This is needed to prevent someone else from deleting the master row
>before commit.  (Since the someone else can't see your uncommitted row,
>nothing but a lock could stop them from thinking it's OK to remove the
>master row.)
>
>So if two sessions are trying to insert rows that reference the same
>master row, they conflict --- because the only type of row-level lock
>we have at the moment is exclusive.  I believe Alvaro is looking into
>supporting shared row-level locks for 8.1, which'd make this problem
>go away.
>
>            regards, tom lane
>
>
>
Ok I think thats the problem.. because

client1:

...
conn.setAutoCommit(false)
insert into liefAdress(adress,postcode)
//id is autoincrement
insert into liefAdress(adress2,postcode2)
....
....


postcode is a FK to a list with postcodes. When I want insert different
postcodes they are no locked.. there is only locked when the postcode are
same. But why there are locked? Have anybody a good
Idea to deal with this problem..?


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: lock problem when dont commit
Next
From: Stéphane RIFF
Date:
Subject: Re: Connection pool problem