Strange row locking - question

From: Vaclav Kulakovsky <vaclav(dot)kulakovsky(at)definity(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange row locking - question
Date: 2002-04-11 14:06:50
Message-ID: Pine.LNX.4.44.0204111557180.29583-100000@vigo.diz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

When I update row in table with foring key, referenced row is locked. I
can see it in log file:

DEBUG: query: update entry set sometext = 'aaa' where id = 1;
DEBUG: query: SELECT 1 FROM ONLY "languages" WHERE "id" = $1 FOR UPDATE
OF "languages"

When I execute update second time I receive only this:

query: update entry set sometext = 'aaa' where id = 1;

Referenced row is locked only first time ? This behavior looks me little
bit strange. Can anybody explain it ?

Regards,

Vaclav

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel POURE 2002-04-11 14:25:34 Re: Transactional vs. Read-only (Retrieval) database
Previous Message Herb Blacker 2002-04-11 13:46:59 Error Message