Thread: How can I know that record is locked?

How can I know that record is locked?

From
Jarosław Jankowski
Date:
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.