Received: from gumby.usu.edu (gumby.usu.edu [129.123.1.117]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB1NNFF32250 for ; Fri, 1 Dec 2000 18:23:15 -0500 (EST) (envelope-from rmello@cc.usu.edu) Received: from cc.usu.edu ("port 2053"@slxwy.dorms.usu.edu [129.123.236.160]) by cc.usu.edu (PMDF V5.2-32 #39375) with ESMTP id <01JX72V0TYZW95ORYD@cc.usu.edu> for pgsql-sql@postgresql.org; Fri, 1 Dec 2000 16:23:25 MST Date: Fri, 01 Dec 2000 16:25:36 -0700 From: Roberto Mello Subject: Re: I can be a BUG? To: Tom Lane Cc: "Edipo E. F. Melo" , pgsql-sql , "sara@conectiva.com.br" , "sarafabiana@starmedia.com" Message-id: <3A283370.B6F8BD19@cc.usu.edu> MIME-version: 1.0 X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.16 i586) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Priority: 1 (Highest) X-Accept-Language: en, pt-BR References: <200012012250.eB1MoQF29124@mail.postgresql.org> <15559.975711642@sss.pgh.pa.us> X-Archive-Number: 200012/10 X-Sequence-Number: 341 Tom Lane wrote: > > It kinda sounds like your wife created those tables in template1. > > Duplicating template1's contents into new databases isn't a bug, > it's a feature ;-) I've seen this behaviour too. Yesterday I pg_dumpall my 7.01 db compiled from scratch and loaded in PG 7.02 installed from Debian packages (I know a pg_dumpall wasn't needed, but I did it anyway). When I went into psql, I was some of my databases with all the pg_* tables. Why? Also, if I dropdb the database and createdb it again, it's as if I never deleted it. Is that normal/bug/feature? Why? -Roberto P.S: It's nice to see some Brazilians on the list :) I am from Brazil too. I hope Conectiva is promoting PostgreSQL down there. -- Computer Science Utah State University Space Dynamics Laboratory Web Developer USU Free Software & GNU/Linux Club http://fslc.usu.edu My home page - http://www.brasileiro.net/roberto