Locks information

Ups, i didn't explain well. What i meant is that i need, in the source code of the 7.3.4 version, the name of the file or files involve in the locking, i.e., in which file a transaction is locked, where is "waken up" when the lock is released and those things.
-------
to: Rajesh Kumar Mallah <mallah@trade-india.com>
cc: pgsql-general@postgresql.org
date: 11/11/2003 12:15:27 PM
subject: Re: [GENERAL] Locks information

you can have a look at

select * from pg_locks;

this works in postgresql ver 7.3

regds

mallah.

Fernando wrote:

Hello,

I'm quite new with PostgreSQL, so this question might be quite dumb, but is there any structure storing information about the transactions which are locked in a moment? I mean, is there, for example, an array with the IDs of the transactions which are locked in the same object? If so, what is its name?

Thanks in advance!

____________________________________________________________

http://webmail.wanadoo.es. Tu correo gratuito, r���pido y en espa���ol

---------------------------(end of broadcast)---------------------------

TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

____________________________________________________________
http://webmail.wanadoo.es. Tu correo gratuito, r���pido y en espa���ol

On Tue, Nov 11, 2003 at 12:20:42PM -0500, Fernando wrote:

Ups, i didn't explain well. What i meant is that i need, in the source
code of the 7.3.4 version, the name of the file or files involve in
the locking, i.e., in which file a transaction is locked, where is
"waken up" when the lock is released and those things.

src/backend/storage/lmgr perhaps? There's a very informative README
there.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Por suerte hoy explot� el califont porque si no me habr�a muerto
de aburrido" (Papelucho)

you can have a look at
select * from pg_locks;

this works in postgresql ver 7.3

regds
mallah.

Fernando wrote: