pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
PGAdmin "Jobs" 2+ messages / 2 participants [nested] [flat]
* PGAdmin "Jobs" @ 2006-07-07 00:25 adey <adey11@gmail.com> 2006-07-07 14:08 ` Re: PGAdmin "Jobs" Andy Shellam <andy@andycc.net> 0 siblings, 1 reply; 2+ messages in thread From: adey @ 2006-07-07 00:25 UTC (permalink / raw) To: pgsql-admin; postgresql-l <postgresql-l@Groups.ittoolbox.com>; pgadmin-support-request@postgresql.org 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? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PGAdmin "Jobs" 2006-07-07 00:25 PGAdmin "Jobs" adey <adey11@gmail.com> @ 2006-07-07 14:08 ` Andy Shellam <andy@andycc.net> 0 siblings, 0 replies; 2+ messages in thread From: Andy Shellam @ 2006-07-07 14:08 UTC (permalink / raw) To: 'adey' <adey11@gmail.com>; +Cc: pgsql-admin There is a menu item under Display called "System Objects". Enable this, restart PgAdmin. Then when you connect you'll have all schemas/objects listed. _____ From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of adey Sent: 07 July 2006 1:26 am To: pgsql-admin@postgresql.org; postgresql-l; pgadmin-support-request@postgresql.org Subject: [ADMIN] PGAdmin "Jobs" 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? !DSPAM:14,44adaa6934531998619277! ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-07-07 14:08 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-07-07 00:25 PGAdmin "Jobs" adey <adey11@gmail.com> 2006-07-07 14:08 ` Andy Shellam <andy@andycc.net>
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