Re: relation ### modified while in use

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: relation ### modified while in use
Дата
Msg-id 002d01c03d7d$78bafaa0$bc7a30d0@sectorbase.com
обсуждение исходный текст
Ответ на RE: relation ### modified while in use  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Список pgsql-hackers
> > > In my understanding,locking levels you provided contains
> > > an implicit share/exclusive lock on the corrsponding
> > > pg_class tuple i.e. AccessExclusive Lock acquires an
> > > exclusive lock on the corresping pg_class tuple and
> > > other locks acquire a share lock, Is it right ?
> >
> > No. Access...Locks are acquired over target table
> > (table' oid is used as key for lmgr hash table),
> > not over corresponding pg_class tuple, in what case
> > we would use pg_clas' oid + table' oid as key
> > (possibility I've described below).
> >
> 
> Yes,I know that "lock table" doesn't touch the correpon
> ding pg_class tuple at all.  However isn't it equivalent ?

From what POV?
Lock manager will allow two simultaneous exclusive locks using these
different methods (keys) and so we can interpret (use) them differently.

Vadim




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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Re: Add support for
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: regress issues: UW7.1.1/PG7.1dev/GCC