"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> writes:
> In my case, being able to view outstanding row level locks would be
> enormously useful.
The only way to do that would be to grovel through every table in the
database, looking for rows that are marked locked by transactions that
are still alive.
> A curious thought struck me: does the pg_lock view follow the mvcc
> rules,
No, not really. If it did I don't think it'd be real useful ...
regards, tom lane