Re: userlock changes for 8.1/8.2

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: userlock changes for 8.1/8.2
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A75E4@Herge.rcsinc.local
обсуждение исходный текст
Ответ на userlock changes for 8.1/8.2  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Ответы Re: userlock changes for 8.1/8.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Alvaro wrote:
> Please search this message in the archives:

right. heh. Well, moving on...

tgl wrote:
> Since subids and offnums are only 16 bits, we could pack all of these
> cases into 64 bits with a 16-bit type identifier to distinguish the
> cases.  That would mean that LOCKTAG doesn't get any bigger than it is
> now, and we'd have plenty of room for expansion still with more types.

Ok, this makes perfect sense, kind of what I was saying only better.

The only thing I can add to it at this point is to reorganize the lock
view(s) correspondingly...should be 1 view for each specific lock type
plus 1 generic one for all locks.   A new datum for the generic lock
type (plus some casts) might be worth considering.

Is it possible for one backend (with superuser privs) to release a lock
held by anotether?

Merlin

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: userlock changes for 8.1/8.2
Следующее
От: Oleg Bartunov
Дата:
Сообщение: ...