How can I know that record is locked? - Mailing list pgsql-general

From Jarosław Jankowski
Subject How can I know that record is locked?
Date
Msg-id 01C1CEC5.63F40460.Jarek@prn.pl
Whole thread Raw
List pgsql-general
Hi, I'am polish programmers in PostgreSQL.

My question is: How can I know that record is locked?
I do SELECT .. FOR UPDATE in transaction, and when selected records is
locked by other user, then my select wait for release lock and hold
program. I want select and lock records. If lock is unavaliable, I want get
any error, instead of wait for release lock.

Please help me.

Thanks for answers.
Jaroslaw Jankowski
jarek@prn.pl

--------------------------------------
Sorry for my language, but I know only technical english for reading
documentation.


pgsql-general by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: [SQL] How to create crude report with psql and/or plpgsql
Next
From: sys@yahoo.com (Enote)
Date:
Subject: is postgres IP address sensitive?