pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard_D_Levine@raytheon.com
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: drdani@mazsola.iit.uni-miskolc.hu, pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: missing schemas from template1
Date: Thu, 16 Dec 2004 13:18:11 -0500
Message-ID: <OF4F00305F.062B5A5D-ON05256F6C.00645E27@ftw.us.ray.com> (raw)

Did you turn on the "view system objects" thingy in pgadmin3?  That's too
technical%|  Okay, I just checked and it's Display->System Objects.


                                                                                                                                           
                      Scott Marlowe                                                                                                        
                      <smarlowe@g2switchwor        To:       Tom Lane <tgl@sss.pgh.pa.us>                                                  
                      ks.com>                      cc:       drdani@mazsola.iit.uni-miskolc.hu, pgsql-admin@postgresql.org                 
                      Sent by:                     Subject:  Re: [ADMIN] missing schemas from template1                                    
                      pgsql-admin-owner@pos                                                                                                
                      tgresql.org                                                                                                          
                                                                                                                                           
                                                                                                                                           
                      12/16/2004 01:05 PM                                                                                                  
                                                                                                                                           
                                                                                                                                           




On Thu, 2004-12-16 at 11:59, Tom Lane wrote:
> drdani@mazsola.iit.uni-miskolc.hu writes:
> > On Thu, 16 Dec 2004, Tom Lane wrote:
> >> It's difficult to believe that those aren't there, or that the
database
> >> would appear to work if they were not.
>
> > The databse is not useable, so that's right.
>
> >> Are you able to do, say, "select
> >> * from pg_namespace"?
>
> > The system is closed, I have no access to it from home, so I can't try
> > it right now. The answer is surely no.
>
> If not, why are you so certain that the problem is with missing schemas
> and not something else?  I would think it would be impossible to do any
> investigation at all, if the initial catalog contents are messed up that
> badly.

Maybe the hosting company is running 7.2 or something like that?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html






view thread (12+ messages)  latest in thread

Message-ID: <OF4F00305F.062B5A5D-ON05256F6C.00645E27@ftw.us.ray.com>
Permalink:  ../OF4F00305F.062B5A5D-ON05256F6C.00645E27@ftw.us.ray.com/
Also on:    postgresql.org/message-id/OF4F00305F.062B5A5D-ON05256F6C.00645E27@ftw.us.ray.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: Richard_D_Levine@raytheon.com, smarlowe@g2switchworks.com, tgl@sss.pgh.pa.us
  Subject: Re: missing schemas from template1
  In-Reply-To: <OF4F00305F.062B5A5D-ON05256F6C.00645E27@ftw.us.ray.com>
  References: <OF4F00305F.062B5A5D-ON05256F6C.00645E27@ftw.us.ray.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