Non-blocking LOCK

Поиск
Список
Период
Сортировка
От Knut Aksel Røysland
Тема Non-blocking LOCK
Дата
Msg-id 200006271756.29991.ganglot@ifi.uio.no
обсуждение исходный текст
Список pgsql-general
Hi.

How can I request a lock in a non-blocking way? Instead of blocking
until a certain lock can be acquired, I would like my client
applications to give up immediately when a conflicting lock exists.

My wish is that client applications locks the data while it is being
edited, thus making the locks possibly long-lived. Subsequent update
requests to the same data, will then be rejected immediately. I am
hoping to find a server-side solution to this problem, so that rude
clients are unable to circumvent the lock.

Is the "user_locks" module (which "provides support for user-level
long-term cooperative locks") the best approach? It appears that this
solution requires well-behaving clients. Do I have other choices?


Sincerely,
Knut Aksel R�ysland

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: disk backups
Следующее
От: "kurt miller"
Дата:
Сообщение: NOTICE messages during table drop