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@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
