<div style="background-color:"><br /><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span class="EmailStyle20"><font
size="2"><fontface="Arial">I have written the following query that ties together locks with databases and users, but I
cannotdetermine from the columns in each of the views used how to associate this data with objects (tables, views,
rows)in the Postgres database:-</font></font></span><p><br />select <br />relation<br />, transaction<br />, pid<br />,
mode<br/>, granted<br />, datname<br />, procpid<br />, u.usesysid <br />, u.usename<br />, usesuper<br />--*<br />from
pg_locksl, pg_stat_activity s, pg_user u<br />where l.pid = s.procpid and s.usesysid = u.usesysid<br />order by
l.pid;<br/><p>Help please?<br /><div><p>Adrian</div></div><br clear="all" /><hr />Become a fitness fanatic with <a
href="http://g.msn.com/8HMAENNZ/2728??PS=47575"target="_top">XtraMSN Health & Fitness!</a>