Re: 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(at)postgresql(dot)org
>
>