X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 32F579FA441 for ; Thu, 6 Jul 2006 21:25:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 25479-09 for ; Thu, 6 Jul 2006 21:25:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 179BA9F94F3 for ; Thu, 6 Jul 2006 21:25:38 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so2894487ugf for ; Thu, 06 Jul 2006 17:25:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=KBKKCYAengNhfnCjJck6hV23TVjuTFuJoKhPEY5SmGQC9urimkawXcQ01z3btlBSp1Vg8Y9YnepJbMoaKTL1gTK3V1ZjTpbUYMNqTj24Pr5fbf5XYx4oAqz5RleYGKD7/vqRA5rARlpmqtXIFPT/XpWfalZu1PaEDbtLbMceWAM= Received: by 10.66.224.19 with SMTP id w19mr1367521ugg; Thu, 06 Jul 2006 17:25:36 -0700 (PDT) Received: by 10.66.234.17 with HTTP; Thu, 6 Jul 2006 17:25:36 -0700 (PDT) Message-ID: <1c66bda80607061725i64bb9fcaycfb26b3dae881c85@mail.gmail.com> Date: Fri, 7 Jul 2006 12:25:36 +1200 From: adey To: "pgsql-admin@postgresql.org" , postgresql-l , pgadmin-support-request@postgresql.org Subject: PGAdmin "Jobs" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_38211_8822460.1152231936870" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/38 X-Sequence-Number: 22284 ------=_Part_38211_8822460.1152231936870 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Please assist me in implementing this for the first time? I have installed Postgres 8.1.4 on my laptop, including Admin, then accessed the database "postgres" from PGAdmin 1.4.2 and run the "pgagent.sql" script tp populate the database with the following result:- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pga_jobagent_pkey" for table "pga_jobagent" NOTICE: CREATE TABLE will create implicit sequence "pga_jobclass_jclid_seq" for serial column "pga_jobclass.jclid" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pga_jobclass_pkey" for table "pga_jobclass" NOTICE: CREATE TABLE will create implicit sequence "pga_job_jobid_seq" for serial column "pga_job.jobid" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pga_job_pkey" for table "pga_job" NOTICE: CREATE TABLE will create implicit sequence "pga_jobstep_jstid_seq" for serial column "pga_jobstep.jstid" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pga_jobstep_pkey" for table "pga_jobstep" NOTICE: CREATE TABLE will create implicit sequence "pga_schedule_jscid_seq" for serial column "pga_schedule.jscid" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pga_schedule_pkey" for table "pga_schedule" NOTICE: CREATE TABLE will create implicit sequence "pga_exception_jexid_seq" for serial column "pga_exception.jexid" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pga_exception_pkey" for table "pga_exception" NOTICE: CREATE TABLE will create implicit sequence "pga_joblog_jlgid_seq" for serial column "pga_joblog.jlgid" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pga_joblog_pkey" for table "pga_joblog" NOTICE: CREATE TABLE will create implicit sequence "pga_jobsteplog_jslid_seq" for serial column "pga_jobsteplog.jslid" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pga_jobsteplog_pkey" for table "pga_jobsteplog" Query returned successfully with no result in 1407 ms. ...but these objects don't appear in PGAdmin under the postgres database. If I rerun all or part of this script, it says the object already exists, and I can see the objects through psql from the command line, eg: select * from pgagent.pga_jobstep. How do I get these objects to appear in PGAdmin please, and how do I get the schema "Information Schema" to appear too? ------=_Part_38211_8822460.1152231936870 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Please assist me in implementing this for the first time?
I have installed Postgres 8.1.4 on my laptop, including Admin, then accessed the database "postgres" from PGAdmin 1.4.2 and run the "pgagent.sql" script tp populate the database with the following result:-
 

NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pga_jobagent_pkey" for table "pga_jobagent"
NOTICE:  CREATE TABLE will create implicit sequence "pga_jobclass_jclid_seq" for serial column "pga_jobclass.jclid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pga_jobclass_pkey" for table "pga_jobclass"
NOTICE:  CREATE TABLE will create implicit sequence "pga_job_jobid_seq" for serial column "pga_job.jobid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pga_job_pkey" for table "pga_job"
NOTICE:  CREATE TABLE will create implicit sequence "pga_jobstep_jstid_seq" for serial column "pga_jobstep.jstid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pga_jobstep_pkey" for table "pga_jobstep"
NOTICE:  CREATE TABLE will create implicit sequence "pga_schedule_jscid_seq" for serial column "pga_schedule.jscid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pga_schedule_pkey" for table "pga_schedule"
NOTICE:  CREATE TABLE will create implicit sequence "pga_exception_jexid_seq" for serial column "pga_exception.jexid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pga_exception_pkey" for table "pga_exception"
NOTICE:  CREATE TABLE will create implicit sequence "pga_joblog_jlgid_seq" for serial column "pga_joblog.jlgid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pga_joblog_pkey" for table "pga_joblog"
NOTICE:  CREATE TABLE will create implicit sequence "pga_jobsteplog_jslid_seq" for serial column "pga_jobsteplog.jslid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pga_jobsteplog_pkey" for table "pga_jobsteplog"

Query returned successfully with no result in 1407 ms.

...but these objects don't appear in PGAdmin under the postgres database. If I rerun all or part of this script, it says the object already exists, and I can see the objects through psql from the command line, eg: select * from pgagent.pga_jobstep.

How do I get these objects to appear in PGAdmin please, and how do I get the schema "Information Schema" to appear too?

 

 

 

------=_Part_38211_8822460.1152231936870--