Little, Douglas wrote: <br /><br /><blockquote cite="mid:8585BA53443004458E0BAA6134C5A7FB0CB29045@EGEXCMB01.oww.root.lcl"type="cite"><div class="WordSection1"><p class="MsoNormal">RunningPGAdmin 1.10.3 on win xp sp3 against Greenplum 3.3.6.6 (PG 8.1.4)</div></blockquote><br /> I thinkyou mean PG 8.2.4 there.<br /><br /> If you're not already familiar with how Greenplum uses resource queues, some backgroundthere might help explain why the things you're looking at require queries against it:<br /><br /><a class="moz-txt-link-freetext" href="http://www.greenplum.com/docs/3300/CREATE_RESOURCE_QUEUE.html">http://www.greenplum.com/docs/3300/CREATE_RESOURCE_QUEUE.html</a><br /><aclass="moz-txt-link-freetext" href="http://www.greenplum.com/docs/3300/sql-alterrole.html">http://www.greenplum.com/docs/3300/sql-alterrole.html</a><br /><aclass="moz-txt-link-freetext" href="http://www.greenplum.com/docs/3300/DROP_RESOURCE_QUEUE.html">http://www.greenplum.com/docs/3300/DROP_RESOURCE_QUEUE.html</a><br /><br/> The DROP page in particular shows examples that retrieve similar things to the pg_resqueue query you're seeing run.<br/><br /><pre class="moz-signature" cols="72">-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support <a class="moz-txt-link-abbreviated" href="mailto:greg@2ndQuadrant.com">greg@2ndQuadrant.com</a> <a class="moz-txt-link-abbreviated"href="http://www.2ndQuadrant.us">www.2ndQuadrant.us</a> </pre>
pgadmin-support by date:
Соглашаюсь с условиями обработки персональных данных