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 по дате отправления: