Re: [BUGS] drop + create database restores previous tables and data

2005-05-22 Thread John Hansen
Maybe you restored to template1 by mistake? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Toltzman > Sent: Monday, May 23, 2005 4:38 AM > To: pgsql-bugs@postgresql.org > Subject: [BUGS] drop + create database restores

[BUGS] drop + create database restores previous tables and data

2005-05-22 Thread Douglas Toltzman
I just installed Postgres v 8.0.3. I loaded by databases, then decided to reload a database. I dropped the database with dropdb (I also tried DROP DATABASE in pgsql), then I recreated the database with createdb. When I tried to reload the data from the database dump, I got errors because the