Row Level Locking Problem

From: "Cray2" <cray2(at)mail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Row Level Locking Problem
Date: 2000-08-20 12:33:50
Message-ID: 8noj66$s5l$1@titan.bt.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I have a big problem, when I try to lock a row locked previouly, It wait
until commit / rollback operation.

How could lock a row if It is not locked already?

Could I now if a row is locked?

Could I get some error message from postgres when I do 'select ....
for update' to a locked row instead of wait for commit / rollback?

cray2(at)mail(dot)com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2000-08-20 13:47:28 mac.c
Previous Message Peter Eisentraut 2000-08-20 11:59:14 Re: autoconf check for AF_UNIX sockets