Thread: Locks

Locks

From
Alfranio Correia Junior
Date:
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


Re: Locks

From
Heikki Linnakangas
Date:
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


Re: Locks

From
Alfranio Correia Junior
Date:
I mean, any C function.