Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB23R6F44523 for ; Fri, 1 Dec 2000 22:27:06 -0500 (EST) (envelope-from reedstrm@rice.edu) Received: by rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgresql.org; Fri, 1 Dec 2000 21:27:06 -0600 (CST) Date: Fri, 1 Dec 2000 21:27:06 -0600 From: "Ross J. Reedstrom" To: Roberto Mello Cc: Tom Lane , "Edipo E. F. Melo" , pgsql-sql , "sara@conectiva.com.br" , "sarafabiana@starmedia.com" Subject: Re: I can be a BUG? Message-ID: <20001201212706.A32124@rice.edu> Mail-Followup-To: Roberto Mello , Tom Lane , "Edipo E. F. Melo" , pgsql-sql , "sara@conectiva.com.br" , "sarafabiana@starmedia.com" References: <200012012250.eB1MoQF29124@mail.postgresql.org> <15559.975711642@sss.pgh.pa.us> <3A283370.B6F8BD19@cc.usu.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <3A283370.B6F8BD19@cc.usu.edu>; from rmello@cc.usu.edu on Fri, Dec 01, 2000 at 04:25:36PM -0700 X-Archive-Number: 200012/11 X-Sequence-Number: 342 On Fri, Dec 01, 2000 at 04:25:36PM -0700, Roberto Mello wrote: > 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? > Ah, the Debian PostgreSQL package uses a different default convention with psql than a from source compile: if you don't provide a database name, debian psql will connect you to template1. On a from source compile, it'll try to connect to a database that matches your username. Ross