Re: tablelevel and rowlevel locks

Поиск
Список
Период
Сортировка
От Jenny -
Тема Re: tablelevel and rowlevel locks
Дата
Msg-id BAY1-F13314bcLMqvsy00028d1d@hotmail.com
обсуждение исходный текст
Ответ на tablelevel and rowlevel locks  ("Jenny -" <nat_lazy@hotmail.com>)
Ответы Re: tablelevel and rowlevel locks  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
Список pgsql-hackers
>On Thu, Sep 04, 2003 at 08:56:31AM -0700, Jenny - wrote:
> > I am working on a project that involves displaying locking information
> > about each lock taken, whether it be a row level or  table leve llock.
> > When dealing with struct LOCK (src/include/storage) i have noticed that
> > postgreSQL creates a single LOCK  struct for each table in the  db. Like
>if
> > i acquire 2 seperate row level locks on 2 seperate rows, both these
>locks
> > are represented in the same struct LOCK datastructure.
>
>I think the locks would actually by represented by PROCLOCK structures.
>The LOCK structures are for lockable objects, not for actual locks.
>

Well,from what i understand, PROCLOCK stores the TransactionID and the LOCK
its holding lock on ,so
how would PROCLOCK be holding the 'actual' lock as apposed to the lockable
objects?
thanks!

_________________________________________________________________
Use custom emotions -- try MSN Messenger 6.0!
http://www.msnmessenger-download.com/tracking/reach_emoticon


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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: ANONCVS? Is it being updated correctly?
Следующее
От: Jon Jensen
Дата:
Сообщение: Re: Win32 native port