Locks

Started by Alfranio Correia Junioralmost 20 years ago3 messages
#1Alfranio Correia Junior
alfranio@lsd.di.uminho.pt

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

#2Heikki Linnakangas
hlinnaka@iki.fi
In reply to: Alfranio Correia Junior (#1)
Re: Locks

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

#3Alfranio Correia Junior
alfranio@lsd.di.uminho.pt
In reply to: Heikki Linnakangas (#2)
Re: Locks

I mean, any C function.