X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8E7DBD8DC4 for ; Tue, 20 Sep 2005 07:50:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12109-05 for ; Tue, 20 Sep 2005 10:50:01 +0000 (GMT) Received: from web32401.mail.mud.yahoo.com (web32401.mail.mud.yahoo.com [68.142.207.194]) by svr1.postgresql.org (Postfix) with SMTP id 5E5BDD8DF3 for ; Tue, 20 Sep 2005 07:50:00 -0300 (ADT) Received: (qmail 72081 invoked by uid 60001); 20 Sep 2005 10:49:59 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=1b7qB42aVaw/ZFlUUP+YE2BzpmPid/DnYMfTM6sVdu3C0a5SLNH4Blv3fq0dmYbui9mYvupFxXhtDf6xse8HY6/UrOkL5HQOrOYB55sJT1UVnCHn646RgBnRznbNakFEDdtb/8nLcfsDHf+WWp50XC3h+1btRqAkTxW0EXsuTyQ= ; Message-ID: <20050920104959.72079.qmail@web32401.mail.mud.yahoo.com> Received: from [217.155.52.254] by web32401.mail.mud.yahoo.com via HTTP; Tue, 20 Sep 2005 03:49:59 PDT Date: Tue, 20 Sep 2005 03:49:59 -0700 (PDT) From: Francis Tiangco Subject: pgAdmin/pgAgent problems To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-805383592-1127213399=:68735" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.879 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, HTML_20_30=0.504, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/256 X-Sequence-Number: 18993 --0-805383592-1127213399=:68735 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 --0-805383592-1127213399=:68735 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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
 
 
 
 
 
 
--0-805383592-1127213399=:68735--