Re: FW: Delete PostgreSQL Database

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(at)macomb(dot)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(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org]On Behalf Of Dave Page
Sent: Monday, July 22, 2002 2:06 PM
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] FW: Delete PostgreSQL
Database

-----Original Message-----
From: Larry Reagor [mailto:lreagor(at)macomb(dot)com]
Sent: 22 July 2002 19:23
Cc: pgadmin-support-owner(at)postgresql(dot)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.