Postgres Pro
Downloads
Home   >   mailing lists

BUG #3667: Job scheduling with Greenplum fails - Mailing list pgsql-bugs

From Jon Roberts
Subject BUG #3667: Job scheduling with Greenplum fails
Date
Msg-id 200710101714.l9AHEgYt029494@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3667: Job scheduling with Greenplum fails
List pgsql-bugs
Tree view 
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.

pgsql-bugs by date:

Previous
From: Gregory Stark
Date:
Subject: Re: PQmakeEmptyPQresult makes my application dumps core?
Next
From: Tom Lane
Date:
Subject: Re: BUG #3667: Job scheduling with Greenplum fails