Litao Wu <[EMAIL PROTECTED]> writes:
> How about:

> select c.relname,, l.mode, l.granted,
> a.current_query
> from pg_locks l, pg_class c, pg_stat_activity a
> where
>   l.relation = c.oid
>   AND =  a.procpid
> order by l.granted,;

You can't join to pg_class without eliminating the transaction lock rows
(because they have NULLs in the relation field).

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to