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. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
