Re: detecting deadlocks

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: detecting deadlocks
Дата
Msg-id 200201230231.g0N2Vvj08799@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: detecting deadlocks  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> >     * list of locks held by each (so you could guess what had preceeded)
>
> The trouble is that what we've got at that level is a "lock tag" that's
> just some numbers.  It's difficult (maybe even impossible in some cases)
> to reverse that into something a user would recognize.  Still, we could
> probably do it in enough cases to be useful.
>
> Hey Bruce, do we have a TODO item about giving better deadlock error
> messages?

All we have now is:

        o Add SHOW command to display locks

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: Nic Ferrier
Дата:
Сообщение: Re: implemention of calls to stored procs.
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: detecting deadlocks