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 eB266gF51970 for ; Sat, 2 Dec 2000 01:06:42 -0500 (EST) (envelope-from rmello@cc.usu.edu) Received: from cc.usu.edu ("port 1098"@slxwy.dorms.usu.edu [129.123.236.160]) by cc.usu.edu (PMDF V5.2-32 #39375) with ESMTP id <01JX7GY7CTGA95OSVR@cc.usu.edu> for pgsql-sql@postgresql.org; Fri, 1 Dec 2000 23:06:51 MST Date: Fri, 01 Dec 2000 23:09:04 -0700 From: Roberto Mello Subject: Re: I can be a BUG? To: "Ross J. Reedstrom" Cc: Tom Lane , "Edipo E. F. Melo" , pgsql-sql , "sara@conectiva.com.br" , "sarafabiana@starmedia.com" Message-id: <3A289200.F233B29B@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-Accept-Language: en, pt-BR References: <200012012250.eB1MoQF29124@mail.postgresql.org> <15559.975711642@sss.pgh.pa.us> <3A283370.B6F8BD19@cc.usu.edu> <20001201212706.A32124@rice.edu> X-Archive-Number: 200012/12 X-Sequence-Number: 343 "Ross J. Reedstrom" wrote: > > 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. Bit I did specify my database name. -Roberto -- 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