On Wed, Nov 02, 2005 at 06:30:38PM -0500, Bruce Momjian wrote: > 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. Maybe you should ask the keeper of the TODO to add it... ;P -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
