Обсуждение: Locks

Are there some sort of functions that I could use to know which process
has an exclusive lock on relations, pages, tuples, transactions,
etc... ?


Best regards,

Alfranio Junior

On Sat, 11 Feb 2006, Alfranio Correia Junior wrote:

> Are there some sort of functions that I could use to know which process
> has an exclusive lock on relations, pages, tuples, transactions,
> etc... ?

SELECT * FROM pg_locks;

- Heikki

I mean, any C function.