<div class="WordSection1"><p class="MsoNormal">Hi List,<p class="MsoNormal"> <p class="MsoNormal"> This might not be
theright place to post, but I’ve got a minor patch for pg_top and would like to submit it for review.<p
class="MsoNormal"> <pclass="MsoNormal"> Basically, the rpm version in the repositories pg_top92-3.6.2 doesn’t work
withPostgres 9.2<p class="MsoNormal"> <p class="MsoNormal">#define QUERY_PROCESSES \<p class="MsoNormal">
"SELECTprocpid\n" \<p class="MsoNormal"> "FROM pg_stat_activity;"<p class="MsoNormal"> <p
class="MsoNormal">Itappears that procpid has been renamed to pid at some point, also the column current_query appears
tohave been shortened to query.<p class="MsoNormal">My patch updates a couple of queries to use the new shorter column
names.<pclass="MsoNormal"> <p class="MsoNormal">Where or who should I submit the changes to?<p class="MsoNormal"> <p
class="MsoNormal">Thanks,<pclass="MsoNormal">Brett<div align="center" class="MsoNormal" style="text-align:center"><span
style="mso-fareast-language:EN-GB"><hralign="center" size="1" width="100%" /></span></div><table border="0"
cellpadding="0"class="MsoNormalTable" style="margin-left:2.25pt"><tr style="height:74.8pt"><td
style="width:202.5pt;padding:.75pt.75pt .75pt .75pt;height:74.8pt" valign="top" width="270"><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"CourierNew";mso-fareast-language:EN-GB">Brett Maton<br />t:
+44 (0) 2392 658 264<br/>m: +44 (0) 7427 610 472<br />e: <a href="mailto:matonb@ltresources.co.uk"><span
style="color:blue">matonb@ltresources.co.uk</span></a></span></td><tdstyle="width:225.0pt;padding:.75pt .75pt .75pt
.75pt;height:74.8pt"valign="top" width="300"><p align="right" class="MsoNormal" style="text-align:right"><a
href="http://www.ltresources.co.uk/"><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:blue;mso-fareast-language:EN-GB;text-decoration:none"><imgalt="Description:
http://www.ltresources.co.uk/logow.png"border="0" height="58" id="_x0000_i1026"
src="cid:image003.png@01CDDEAC.0973AF10"width="404" /></span></a><span style="font-size:10.0pt;font-family:"Courier
New";mso-fareast-language:EN-GB"></span></td></tr></table><pclass="MsoNormal"><span
style="mso-fareast-language:EN-GB"> </span><pclass="MsoNormal"> </div>
