Re: DROP DATABASE, but still there

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: DROP DATABASE, but still there
Дата
Msg-id 87k6ssyzrd.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на DROP DATABASE, but still there  (Robert Fitzpatrick <robert@webtent.com>)
Ответы Re: DROP DATABASE, but still there  (Robert Fitzpatrick <robert@webtent.com>)
Список pgsql-general
Robert Fitzpatrick <robert@webtent.com> writes:

> What does it mean when you drop a database and then recreate with the
> same name and all the objects are still there. I want to wipe out the db
> and put back from pg_restore. After I re-create the db, all the old
> tables are back before I run pg_restore.

Check the 'template1' database to see if the tables got put in there
by mistake at some point.

-Doug

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: making another super user other than postgres
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Analyse - max_locks_per_transaction - why?