Re: Row Level Locking Problem

At 02:33 PM 8/20/00 +0200, Cray2 wrote:
>    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?

Well, this is how it is supposed to work.  "select for update" only
works within a transaction and holds the lock until the transaction
is complete.

What exactly is it that you're trying to do?



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.