Re: Need help understanding pg_locks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Need help understanding pg_locks
Дата
Msg-id 13319.1310398865@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Need help understanding pg_locks  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Tom Lane wrote:
>> Maybe we could just add a paragraph above the "pg_locks Columns" table
>> that says explicitly that virtualtransaction and pid describe the entity
>> holding or awaiting the lock, and the others describe the object being
>> locked?  Any way you slice it, putting this information into the
>> per-column table is going to be repetitive.

> Frankly, whenever anyone says "object", they might as well call it
> "thing".  It seems to be a content-less word.  Maybe just replace the
> word "object" with "lock".

No, because that conflates the lock with the thing being locked.
Fuzzing that semantic difference isn't going to make it less confusing.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Need help understanding pg_locks
Следующее
От: Florian Pflug
Дата:
Сообщение: Re: Need help understanding pg_locks