Implicit Lock Row

Поиск
Список
Период
Сортировка
От Antoine Lobato
Тема Implicit Lock Row
Дата
Msg-id 000a01c26cba$1508a480$deb8243e@Wantoine
обсуждение исходный текст
Ответы Re: Implicit Lock Row  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список pgsql-hackers

I currently develop an interface to simulate a indexed sequential file management with PostgreSql. I must reproduce the same philosophy used of control of locking of the records.

I seek a solution to lock and unlock implicitly a row of a table. The locking of several rows, of the same table or various tables, can last a long time and consequently locking cannot be included in a transaction for not to lock the whole table for the other users.

There is a viable solution with PostgreSql?

There is an accessible basic structure of locking?

Thank you.

 

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

Предыдущее
От: Hans-Jürgen Schönig
Дата:
Сообщение: Re: Threaded Sorting
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Use of sync() [was Re: Potential Large Performance Gain in WAL synching]