How can I know that record is locked?

Поиск
Список
Период
Сортировка
От Jarosław Jankowski
Тема How can I know that record is locked?
Дата
Msg-id 01C1CEC5.63F40460.Jarek@prn.pl
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: [SQL] How to create crude report with psql and/or plpgsql
Следующее
От: sys@yahoo.com (Enote)
Дата:
Сообщение: is postgres IP address sensitive?