On Thu, 2004-11-11 at 14:03, Doug McNaught wrote: > Robert Fitzpatrick <[EMAIL PROTECTED]> writes: > > > What does it mean when you drop a database and then recreate with the > > same name and all the objects are still there. I want to wipe out the db > > and put back from pg_restore. After I re-create the db, all the old > > tables are back before I run pg_restore. > > Check the 'template1' database to see if the tables got put in there > by mistake at some point.
Yeah, I was just starting to realize that these objects that keep coming back are in the template1 as well.....any reason why I shouldn't drop the template1 and re-create like any other? -- Robert ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])