-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wed, 19 Mar 2008 17:21:39 -0400
Carol Walter <walterc@indiana.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-----