Re: DROP DATABASE, but still there

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