The following bug has been logged online:
Bug reference: 3667
Logged by: Jon Roberts
Email address: jon.roberts@asurion.com
PostgreSQL version: 8.2
Operating system: Solaris
Description: Job scheduling with Greenplum fails
Details:
Greenplum doesn't support "correlated subqueries" which PGAdmin III uses
when PgAgent is installed.
I suggest the SQL related to PgAgent be re-written to not use correlated
subqueries.