Re: Lock Modes (Documentation)

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461