Re: Locks

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Alfranio Correia Junior <alfranio(at)lsd(dot)di(dot)uminho(dot)pt>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Locks
Date: 2006-02-11 19:04:27
Message-ID: Pine.OSF.4.61.0602112103390.321472@kosh.hut.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

  • Locks at 2006-02-11 15:09:29 from Alfranio Correia Junior

Responses

  • Re: Locks at 2006-02-11 19:52:38 from Alfranio Correia Junior

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Sabino Mullane 2006-02-11 19:30:34 Raising the Pl/Perl required version
Previous Message Mark Woodward 2006-02-11 18:33:39 Analyze and vacuum, they are sort of mandatory....