Dropping Databases

From: David Rickard <David(dot)Rickard(at)GTScompanies(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: Judith Strawser <judiths(at)GTScompanies(dot)com>, "S(dot)R(dot)Ramesh" <sramesh(at)techbooks(dot)com>
Subject: Dropping Databases
Date: 2003-10-07 22:53:12
Message-ID: 5.2.1.1.0.20031007154625.00ab4448@mail.gtscompanies.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

We're working in PostgreSQL 7.3.4; we created a couple of test databases to
get familiar with postgres, then attempted to drop them, using DROP
DATABASE <dbname>; however, get kept getting the following error message:
ERROR: DROP DATABASE: database "<dbname>" does not exist
We could connect to <dbname>, it was listed as a database when we did psql
-l, we could list the tables and select rows from those tables--but we
could not drop the database; we finally deleted it's entry from
pg_catalog.pg_database (which we suspect is a dangerous action, and which
presumably does not eliminate the database disk files);

Any ideas?

--

David Rickard
Software Engineer
The GTS Companies
A TechBooks Company

----------------------------------------------------------------------------------

The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA * York, PA * Boston MA * New Delhi, India
----------------------------------------------------------------------------------

David(dot)Rickard(at)GTSCompanies(dot)com
Visit us on the World Wide Web
http://www.gtscompanies.com
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-10-07 22:56:26 Re: Dropping Databases
Previous Message Jeff Eckermann 2003-10-07 22:16:44 Re: perlsub