Maybe you restored to template1 by mistake?=20
> -----Original Message-----
> From: pgsql-bugs-owner@postgresql.org=20
> [mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Douglas Toltzman
> Sent: Monday, May 23, 2005 4:38 AM
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] drop + create database restores previous=20
> tables and data
>=20
> I just installed Postgres v 8.0.3. I loaded by databases,=20
> then decided to reload a database. I dropped the database=20
> with dropdb (I also tried DROP DATABASE in pgsql), then I=20
> recreated the database with createdb.=20=20
> When I tried to reload the data from the database dump, I got=20
> errors because the relations and data were already in the=20
> newly created database. I've since tried dropping and=20
> recreating several times.=20=20
> After dropping and creating, I can connect to the database=20
> and see all of the data that was there before dropping the=20
> database; without reloading anything.
>=20
> At this early stage, I can remove everything and recreate the=20
> entire installation from scratch, but this will create a real=20
> problem in the future.
>=20
> Douglas Toltzman, Oak Street Software, Inc.
> voice: 910-526-5938
> http://www.oakstreetsoftware.com/
>=20
>=20
> ---------------------------(end of=20
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>=20
>=20
