pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: adey <adey11@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
To: postgresql-l <postgresql-l@Groups.ittoolbox.com>
To: pgadmin-support-request@postgresql.org
Subject: PGAdmin "Jobs"
Date: Fri, 7 Jul 2006 12:25:36 +1200
Message-ID: <1c66bda80607061725i64bb9fcaycfb26b3dae881c85@mail.gmail.com> (raw)

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?

view thread (2+ messages)  latest in thread

Message-ID: <1c66bda80607061725i64bb9fcaycfb26b3dae881c85@mail.gmail.com>
Permalink:  ../1c66bda80607061725i64bb9fcaycfb26b3dae881c85@mail.gmail.com/
Also on:    postgresql.org/message-id/1c66bda80607061725i64bb9fcaycfb26b3dae881c85@mail.gmail.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: adey11@gmail.com, postgresql-l@Groups.ittoolbox.com, pgadmin-support-request@postgresql.org
  Subject: Re: PGAdmin "Jobs"
  In-Reply-To: <1c66bda80607061725i64bb9fcaycfb26b3dae881c85@mail.gmail.com>
  References: <1c66bda80607061725i64bb9fcaycfb26b3dae881c85@mail.gmail.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