From: | "Luke Lonergan" <LLonergan(at)greenplum(dot)com> |
---|---|
To: | "Dave Page" <dpage(at)postgresql(dot)org> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Small change needed to support Greenplum DB |
Date: | 2007-10-12 15:14:12 |
Message-ID: | C3E62232E3BCF24CBA20D72BFDCB6BF8044A22E6@MI8NYCMAIL08.Mi8.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Yes it does!
- Luke
Msg is shrt cuz m on ma treo
-----Original Message-----
From: Dave Page [mailto:dpage(at)postgresql(dot)org]
Sent: Friday, October 12, 2007 10:21 AM Eastern Standard Time
To: Luke Lonergan
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Small change needed to support Greenplum DB
Luke Lonergan wrote:
> Hi all,
>
> A customer of ours is using pgAgent with Greenplum Database and needs a
> change to one of the queries used by pgAgent to allow it to work with
> Greenplum.
>
> Here is the conversation:
> _http://groups.google.com/group/pgsql.bugs/browse_thread/thread/27866354fa4d7a5e/60e6e5de3c5156d4#60e6e5de3c5156d4
>
> _The problem is that Greenplum does not support some correlated
> subqueries, so Jon created a version of the query that is both faster
> and does not use a correlated subquery.
>
> The requested change is from this in pgaJob.cpp:
Hi Luke,
Does Greenplum support DISTINCT ON? Specifically,
SELECT j.*, cl.*, ag.*, sub.jlgstatus
FROM pgagent.pga_job j JOIN
pgagent.pga_jobclass cl ON cl.jclid=jobjclid LEFT OUTER JOIN
pgagent.pga_jobagent ag ON ag.jagpid=jobagentid JOIN
(SELECT DISTINCT ON (jlgjobid) jlgstatus, jlgjobid
FROM pgagent.pga_joblog
ORDER BY jlgjobid, jlgid desc) sub ON sub.jlgjobid = j.jobid
-- + restriction +
ORDER BY jobname;
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-10-12 15:40:08 | Re: Small change needed to support Greenplum DB |
Previous Message | Guillaume Lelarge | 2007-10-12 14:52:37 | Re: Bug report pgadmin 1.8.0 Beta 5 (Sep 10 2007, rev 6631) |