Re: DROP DATABASE, but still there

Поиск
Список
Период
Сортировка
Искать
От
Greg Stark
Тема
Re: DROP DATABASE, but still there
Дата
Msg-id
87ekj0dtti.fsf@stark.xeocode.com
Ответ на
Список
Дерево обсуждения
DROP DATABASE, but still there Robert Fitzpatrick <robert@webtent.com>
Re: DROP DATABASE, but still there Doug McNaught <doug@mcnaught.org>
Re: DROP DATABASE, but still there Robert Fitzpatrick <robert@webtent.com>
Re: DROP DATABASE, but still there Bruno Wolff III <bruno@wolff.to>
Re: DROP DATABASE, but still there Greg Stark <gsstark@mit.edu>
Re: DROP DATABASE, but still there Tom Lane <tgl@sss.pgh.pa.us>

Robert Fitzpatrick  writes:

> Yeah, I was just starting to realize that these objects that keep coming
> back are in the template1 as well.....any reason why I shouldn't drop
> the template1 and re-create like any other?

You can do that but you'll have to do:

  CREATE DATABASE template1 WITH template = 'template0'


-- 
greg
В списке pgsql-general по дате отправления
От: Greg Stark
Дата:
Сообщение: Re: implicit casting problem
От: Andrew Rawnsley
Дата:
Сообщение: Re: comp.database.postgresql.*
FAQ