Skip site navigation (1) Skip section navigation (2)

Re: Connect problem

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Mike Hedman'" <mikehedman(at)yahoo(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Connect problem
Date: 2001-11-06 08:09:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support

> -----Original Message-----
> From: Mike Hedman [mailto:mikehedman(at)yahoo(dot)com] 
> Sent: 06 November 2001 04:52
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Connect problem
> Hi all,
> In pgAdmin II when I connect to my database I only see 
> template0 in my list of databases, though template1 is where 
> all my stuff is.
> I'm a newbie, but I have things mostly set up correctly with 
> Postgresql 7.1.3 on cygwin.  I'm able to access my tables 
> using jsp's, so I'm pretty sure the plumbing is working correctly.
> Is there a setting in pgAdmin that I'm missing?

Hi Mike,

Try switching on 'system Objects' on the view menu - template1 is classed as
a system object.

I would suggest however that you *not* use template1 for your data; there
are 2 template databases by default, template0 & template1. template0 is a
blank database that cannot be modified, but template1 (which is the default
and is copied when you create a new database) is a blank database that can
be modified. This is to allow system administrators to add objects to
template1 that they want to appear in all new databases. Typically this
might include the definitions for pl/pgsql (or another procedural language),
or some useful functions.

Hth, regards, Dave.

pgadmin-support by date

Next:From: Anil JangamDate: 2001-11-06 11:34:13
Subject: Invalid procedure call or argument
Previous:From: Mike HedmanDate: 2001-11-06 04:51:31
Subject: Connect problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group