pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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-----


view thread (3+ messages)  latest in thread

Message-ID: <20080319145939.22c27b0a@commandprompt.com>
Permalink:  ../20080319145939.22c27b0a@commandprompt.com/
Also on:    postgresql.org/message-id/20080319145939.22c27b0a@commandprompt.com

 · 

reply

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