check if table/object is locked

Поиск
Список
Период
Сортировка
От Jonathan Weiss
Тема check if table/object is locked
Дата
Msg-id 28935.1047222888@www1.gmx.net
обсуждение исходный текст
Ответы Re: check if table/object is locked  (Rod Taylor <rbt@rbt.ca>)
Список pgsql-sql
hi!


i have a problem. i developed an application for administrating cliet and
their sales. if i want to edit a client i load him by select for update. now if
another person want to update him, the query waits, until the first
connection is closed. this is unacceptable, because the whole application is doing
nothing until the db is responding. how can i check if the client is locked
before i want to load him?

thanks,


Jonathan Weiss

-- 
+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!



В списке pgsql-sql по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: pl/pgsql how to return multiple values from a function
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: check if table/object is locked