Re: DROP DATABASE, but still there

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Robert Fitzpatrick <robert(at)webtent(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: DROP DATABASE, but still there
Date: 2004-11-11 19:03:18
Message-ID: 87k6ssyzrd.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Robert Fitzpatrick <robert(at)webtent(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-11 19:14:34 Re: Analyse - max_locks_per_transaction - why?
Previous Message Tom Lane 2004-11-11 19:01:08 Re: making another super user other than postgres