Re: Row level locking

On Wed, Oct 12, 2005 at 04:11:00AM +0000, Carlos Benkendorf wrote:
> How can I know which rows are locked?

There's no query that says "show me all rows that are locked"; even
if there was, it would be out of date by the time you got the
results.  PostgreSQL 8.1 will enhance pg_locks to show tuple locks
in certain cases but it won't show all tuple locks.

Why do you want to know?  What are you trying to do?

--
Michael Fuhr