Jim C. Nasby wrote:
> On Wed, Nov 02, 2005 at 05:59:15PM -0500, Bruce Momjian wrote:
> > Actually, pre-8.1 used ROW EXCLUSIVE for foreign keys because we didn't
> > have ROW SHARE until 8.1. I actually can't find out how we are doing
> > that in the code, however. Analyzing the code is probably the only way
> > to get this detailed lock information.
>
> Would it be feasable to have the lock manager spew out info about lock
> aquisition and release? Not only would it make getting this information
> easy, but I suspect it could be a useful debugging tool.
Something like log_locks? That would be valuable.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073