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

Поиск
Список
Период
Сортировка

Locks

От
Alfranio Correia Junior
Дата:
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

От
Heikki Linnakangas
Дата:
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

От
Alfranio Correia Junior
Дата:
I mean, any C function.