-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 19 Mar 2008 17:21:39 -0400 Carol Walter <walterc@xxxxxxxxxxx> 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----- -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin
