pg_locks: who is locking ?

Hi,

My Database have a lot of locks not granted every moments in a day.

Can I create a view that returns someting like this ?

User    Granted    Table    Who_is_locking_me  PID
----    -------    -----    -----------------  ---
joe    f    foo    frank              1212
jeff    f    foo    frank              1313
ann    f    foo    frank              1414
frank    t    foo                   1111
(...)

(Or the locked transactions, if the table cold't be retrived)

pg_locks view does not give me WHO is locking...


Best regards,

Alexandre