Postgres Pro
Downloads
Home   >   mailing lists

Row Level Locking Problem - Mailing list pgsql-hackers

From Cray2
Subject Row Level Locking Problem
Date
Msg-id 8noj66$s5l$1@titan.bt.es
Whole thread Raw
Responses Re: Row Level Locking Problem
List pgsql-hackers
Tree view 
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@mail.com

pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan
Next
From: Hannu Krosing
Date:
Subject: Re: Optimisation deficiency: currval('seq')-->seqscan, constant-->index scan