trivial patch: show SIREAD pids in pg_locks

Поиск
Список
Период
Сортировка
От Dan Ports
Тема trivial patch: show SIREAD pids in pg_locks
Дата
Msg-id 20110401170028.GK81592@csail.mit.edu
обсуждение исходный текст
Ответы Re: trivial patch: show SIREAD pids in pg_locks  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: trivial patch: show SIREAD pids in pg_locks  (Jeff Davis <pgsql@j-davis.com>)
Re: trivial patch: show SIREAD pids in pg_locks  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
While looking into a SSI bug, I noticed that we don't actually display
the pid of the holding transaction, even though we have that
information available.

The attached patch fixes that.

One note is that it will show the pid of the backend that executed the
transaction, even if that transaction has already committed. I have no
particular opinion about whether it's more useful to do that or return
null, so went with the smallest change. (The pid is null for PREPARED
or summarized transactions).

Dan

--
Dan R. K. Ports              MIT CSAIL                http://drkp.net/

Вложения

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Should psql support URI syntax?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Should psql support URI syntax?