Request a Demo
Home   >   mailing lists

Re: FW: Delete PostgreSQL Database - Mailing list pgadmin-support

From Dave Page
Subject Re: FW: Delete PostgreSQL Database
Date
Msg-id D85C66DA59BA044EB96AB9683819CF61137F93@dogbert.vale-housing.co.uk
Whole thread Raw
In response to FW: Delete PostgreSQL Database  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-support
Tree view
The code that *should* work was written was left in. I suppose it should be commented out though. If you're interested, the reason you can't drop the database is because Microsoft ADO helpfully keeps the connection open for reuse should we need it (a technique called pooling). 
 
Regards, Dave.
-----Original Message-----
From: Larry Reagor [mailto:lreagor@macomb.com]
Sent: 23 July 2002 04:51
To: Dave Page
Subject: RE: [pgadmin-support] FW: Delete PostgreSQL Database

I was able to drop an unwanted one earlier from pgAdmin (pgAdmin II) when I was just testing the Access migration plug in.  Why is there a drop command available for databases if I can't do it from pgAdmin?
Larry
-----Original Message-----
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]On Behalf Of Dave Page
Sent: Monday, July 22, 2002 2:06 PM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] FW: Delete PostgreSQL Database

 
-----Original Message-----
From: Larry Reagor [mailto:lreagor@macomb.com]
Sent: 22 July 2002 19:23
Cc: pgadmin-support-owner@postgresql.org
Subject: Delete PostgreSQL Database

I attempt to delete (drop) a database and get the following message.
 
 
I am the only user. What do I have to do to delete an unwanted database?

Unfortunately you can't using pgAdmin (see http://www.pgadmin.org/pgadmin2.php?ContentID=9). The best way is to close pgAdmin and use psql on the server.
 
Regards, Dave.

pgadmin-support by date:

Previous
From: lmvt10cller@freemail.ru
Date:
Subject: As low as 10 cents on the Dollar! dxlpm
Next
From: "Dave Page"
Date:
Subject: Re: Error Msg in pgAdmin II 1.3.60