[HACKERS] bitmask for lock types

2003-03-11 Thread Sumaira Ali
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

[HACKERS] how to get actual PGPROC and LOCK object from SHMEM_OFFSET???

2003-03-11 Thread Sumaira Ali
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

[HACKERS] specific questions regarding Oid and finding out the granularity of the lock

2003-03-11 Thread Sumaira Ali
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

[HACKERS] locking mechanism

2003-02-23 Thread Sumaira Ali
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*.

[HACKERS] PGRPROC

2003-02-18 Thread Sumaira Ali
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

[HACKERS] lock method

2003-02-12 Thread Sumaira Ali
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*.