The way I understand it, grantMask in the LOCK struct (file Lock.h) could help us find out all the lock types already granted for an object associated with the LOCKTAG.
How do we do the bit manipulation to 'separate' the mask to get to the different lock types associated with the object that
How do we get the actual pgproc object from the
SHMEM_OFFSET proc /* link to pgproc of owning backend*/ in the PROCLOCKTAG struct in file Lock.h
The same question also for SHMEM_OFFSET lock /*link to per-lockable-object information*/ in the same struct
Is SHMEM_OFFSETa pointer to an address which
what are the different types of lock modes available for row-level locks?
I found a documentation on different types of lock modes available for table-level locks at
http://developer.postgresql.org/docs/postgres/explicit-locking.html
where is the documentation on different types of lock modes for
hi,
i wanted to know whether in postgresql, asingleprocess can wait on acquiring multiple locks and if can hold
multiple locks at the same time?
thanks
sumairaMSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.
if pgproc is used to represent a process and proclock represents a process and its locks of interest, then why does pgproc contain the following information about locks?
/*
* XLOG location of first XLOG record written by this backend's
* current transaction. If backend is not in a transaction or
hi, does anyone know what lockmethod means in the lock.h file and whats the use of lockmethodTable.?
thank you
SumairaAdd photos to your messages with MSN 8. Get 2 months FREE*.