Re: Can pessimistic locking be emulated?

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Can pessimistic locking be emulated?
Дата
Msg-id 1046368549.91396.74.camel@jester
обсуждение исходный текст
Ответ на Re: Can pessimistic locking be emulated?  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Ответы Re: Can pessimistic locking be emulated?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> In my case, being able to view outstanding row level locks would be
> enormously useful.  I'm assuming this is not possible for structural or

Agreed -- but they're stored on the row themselves.  You might be able
to write a function which executes dirty reads on the table and tells
you if the row is locked or not, but it's not going to be simple.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can pessimistic locking be emulated?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: analyze after a database restore?