hi,
 Iam working on project that deals with analyzing the locking mechanism in postgresql. 
I started a transaction in postgresql with 'begin work;' and noticed that even though no locks have been taken yet, there still exists data in LockData datastructures that indicates that the transaction i just started running is waiting for a lock.Does anyone know why this happens? I f not , could someone guide me to the appropriate site or mailinglist where my question can be answered.
thank you
JennyProtect your PC - Click here for McAfee.com VirusScan Online 

Tue, 08 Jul 2003 07:41:48 -0700
"Jenny -" <nat_lazy@hotmail.com>
running transactions in postgresql
On Tue, Jul 08, 2003 at 07:41:48AM -0700, Jenny - wrote:

> [unquotable HTML, please post only text/plain!]

At transaction start
(src/backend/access/transam/xact.c::StartTransaction()),
src/backend/storage/lmgr/lmgr.c::XactLockTableInsert() is executed,
which takes a special lock on a ficticious XactLockTableId.

Maybe that's what you are seeing?

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Uno puede defenderse de los ataques; contra los elogios se esta indefenso"

Wed, 9 Jul 2003 19:39:46 -0400
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: running transactions in postgresql