Re: Empty database creation???

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 19 Mar 2008 17:21:39 -0400
Carol Walter <walterc(at)indiana(dot)edu> wrote:

The tables were there and populated. I've
> even made sure the database was dropped by listing the databases.
> Still, when I recreate it, it comes with all the tables there and
> populated. I've worked with a lot of databases and everything in my
> experience says that when a database is dropped it's gone. Why does
> this come back with all the tables intact when I drop it and recreate
> a database with the same name? Is there a way I can this to work? I
> have not tried creating the empty database under a name I haven't
> used, which I can do. It's just that this seems really weird to me.

You probably have template1 with data in it.

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH4YzLATb/zqfZUUQRAvpjAKCSLje0tGAphePMMvr2sH8aaZyTGACfYHga
zcPXk8u01igHmUP2tZRYNIo=
=WZMs
-----END PGP SIGNATURE-----