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]
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 |