Re: Small change needed to support Greenplum DB

<p><font size="2">Thanks Dave - much appreciated, pgadmin is a great product.<br /><br /> - Luke<br /><br /> Msg is
shrtcuz m on ma treo<br /><br />  -----Original Message-----<br /> From:   Dave Page [<a
href="mailto:dpage@postgresql.org">mailto:dpage@postgresql.org</a>]<br/> Sent:   Friday, October 12, 2007 11:41 AM
EasternStandard Time<br /> To:     Luke Lonergan<br /> Cc:     pgadmin-support@postgresql.org<br /> Subject:        Re:
[pgadmin-support]Small change needed to support Greenplum DB<br /><br /> Thanks Luke - fix committed for 1.8 using the
DISTINCTON version of the<br /> query.<br /><br /> Regards, Dave<br /><br /> Luke Lonergan wrote:<br /> > Yes it
does!<br/> ><br /> > - Luke<br /> ><br /> > Msg is shrt cuz m on ma treo<br /> ><br /> > 
-----OriginalMessage-----<br /> > From:   Dave Page [<a
href="mailto:dpage@postgresql.org">mailto:dpage@postgresql.org</a>]<br/> > Sent:   Friday, October 12, 2007 10:21 AM
EasternStandard Time<br /> > To:     Luke Lonergan<br /> > Cc:     pgadmin-support@postgresql.org<br /> >
Subject:       Re: [pgadmin-support] Small change needed to support<br /> > Greenplum DB<br /> ><br /> > Luke
Lonerganwrote:<br /> >> Hi all,<br /> >><br /> >> A customer of ours is using pgAgent with Greenplum
Databaseand needs a<br /> >> change to one of the queries used by pgAgent to allow it to work with<br /> >>
Greenplum.<br/> >><br /> >> Here is the conversation:<br /> >> <br /> > _<a
href="http://groups.google.com/group/pgsql.bugs/browse_thread/thread/27866354fa4d7a5e/60e6e5de3c5156d4#60e6e5de3c5156d4">http://groups.google.com/group/pgsql.bugs/browse_thread/thread/27866354fa4d7a5e/60e6e5de3c5156d4#60e6e5de3c5156d4</a><br
/>>><br /> >> _The problem is that Greenplum does not support some correlated<br /> >> subqueries, so
Joncreated a version of the query that is both faster<br /> >> and does not use a correlated subquery.<br />
>><br/> >> The requested change is from this in pgaJob.cpp:<br /> ><br /> ><br /> > Hi Luke,<br />
><br/> > Does Greenplum support DISTINCT ON? Specifically,<br /> ><br /> > SELECT j.*, cl.*, ag.*,
sub.jlgstatus<br/> > FROM pgagent.pga_job j JOIN<br /> >      pgagent.pga_jobclass cl ON cl.jclid=jobjclid LEFT
OUTERJOIN<br /> >      pgagent.pga_jobagent ag ON ag.jagpid=jobagentid JOIN<br /> >      (SELECT DISTINCT ON
(jlgjobid)jlgstatus, jlgjobid<br /> >       FROM pgagent.pga_joblog<br /> >       ORDER BY jlgjobid, jlgid desc)
subON sub.jlgjobid = j.jobid<br /> > --       + restriction +<br /> > ORDER BY jobname;<br /> ><br /> >
Regards,Dave.<br /> ><br /><br /></font>