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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

"Jon Roberts" <jon.roberts@asurion.com> writes:
> Greenplum doesn't support "correlated subqueries" which PGAdmin III uses
> when PgAgent is installed.

Surely this complaint should be directed to Greenplum. Correlated
subqueries are a required entry-level feature in the SQL92 standard,
and have been supported by PG for nigh ten years. It is by no means
unreasonable for PGAdmin to expect them to work.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster