From: Joshua D. Drake <jd@commandprompt.com>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Empty database creation???
Date: Wed, 19 Mar 2008 14:59:39 -0700
Message-ID: <20080319145939.22c27b0a@commandprompt.com> (raw)
In-Reply-To: <5603D3A1-DFEE-43D2-9107-66171FDBDEAF@indiana.edu>
References: <5603D3A1-DFEE-43D2-9107-66171FDBDEAF@indiana.edu>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, walterc@indiana.edu
Subject: Re: Empty database creation???
In-Reply-To: <20080319145939.22c27b0a@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox