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

Re: missing schemas from template1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: missing schemas from template1
Date: 2004-12-16 17:01:21
Message-ID: 25662.1103216481@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu writes:
> On Thu, 16 Dec 2004, Tom Lane wrote:
>> Uh ... what schemas are you expecting to find there?

> In normal cases there are:

> information_schema
> pg_catalog
> pg_temp1
> pg_toast
> public

> schemas. Without them the database is not really usefull. When I 
> create the first database (as copy of template1 of course) it misses 
> those schemas. I don't know what is the normal way to create them if 
> `initdb' didn't do it (it just said it did...)

It's difficult to believe that those aren't there, or that the database
would appear to work if they were not.  Are you able to do, say, "select
* from pg_namespace"?

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Sam MortimerDate: 2004-12-16 17:07:01
Subject: Re: robust way of moving tables to a different disk??
Previous:From: Donald FraserDate: 2004-12-16 17:01:04
Subject: Re: Notifications

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