pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Francis Tiangco <fptiangco@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: pgAdmin/pgAgent problems
Date: Tue, 20 Sep 2005 03:49:59 -0700 (PDT)
Message-ID: <20050920104959.72079.qmail@web32401.mail.mud.yahoo.com> (raw)

Platform: Windows XP/Cygwin
PostgreSQL version: 7.4
PgAdmin version: 1.3.0 (Sep 15 2005)
 
Problems/Suggestions:
1. pgAdmin hangs when I view the details of a newly created job (without creating a step or a schedule yet)
 
2. When I do create a job, a step and a schedule at the same time, I get:
ERROR: syntax error at or near "IF"
CONTEXT: compile of PL/pgSQL function "pga_next_schedule" near line 161
PL/pgSQL function "pga_job_trigger" line 4 at select into variables
PL/pgSQL function "pga_schedule_trigger" line 10 at SQL statement
 
3. When running the pgagent.sql script, the pga_job_trigger needs to be edited by deleting a $BODY$ and replace with a single quote. Maybe this can be corrected?
 
4.To be able to view the jobs node, the Maintence DB should be set to the database where you ran pgAgent.sql (This is thanks to Dave Page). Maybe we could include this in the help file.
 
Any help would be appreciated.  Many thanks for your time.
 
Best Regards,
Francis Tiangco
 
 
 
 
 
 

Message-ID: <20050920104959.72079.qmail@web32401.mail.mud.yahoo.com>
Permalink:  ../20050920104959.72079.qmail@web32401.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20050920104959.72079.qmail@web32401.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: fptiangco@yahoo.com
  Subject: Re: pgAdmin/pgAgent problems
  In-Reply-To: <20050920104959.72079.qmail@web32401.mail.mud.yahoo.com>
  References: <20050920104959.72079.qmail@web32401.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox