Re: missing schemas from template1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: missing schemas from template1
Дата
Msg-id 25662.1103216481@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: missing schemas from template1  (drdani@mazsola.iit.uni-miskolc.hu)
Ответы Re: missing schemas from template1  (drdani@mazsola.iit.uni-miskolc.hu)
Список pgsql-admin
drdani@mazsola.iit.uni-miskolc.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Donald Fraser"
Дата:
Сообщение: Re: Notifications
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Notifications