Re: DROP DATABASE, but still there - Mailing list pgsql-general

From Robert Fitzpatrick
Subject Re: DROP DATABASE, but still there
Date
Msg-id 1100200665.11257.34.camel@columbus.webtent.org
Whole thread Raw
In response to Re: DROP DATABASE, but still there  (Doug McNaught <doug@mcnaught.org>)
Responses Re: DROP DATABASE, but still there
Re: DROP DATABASE, but still there
List pgsql-general
On Thu, 2004-11-11 at 14:03, Doug McNaught wrote:
> 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.

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?

--
Robert


pgsql-general by date:

Previous
From: Geoffrey
Date:
Subject: oid size on 64 bit machine
Next
From: jao@geophile.com
Date:
Subject: When to switch to Postgres 8.0?