From: | "Daniel T(dot) Staal" <DStaal(at)usa(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: phppgadmin |
Date: | 2005-06-01 19:46:52 |
Message-ID: | 50947.63.172.115.138.1117655212.squirrel@MageHandbook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Sean said:
> When I try to remove a database with phppgadmin, I get the following
error, "ERROR: cannot drop the currently open database". Any insight
would be appreciated.
This one is fairly direct: When you connect to Postgres, you connect to a
particular database within that install's set. You can drop any database
you aren't connected to, but not the one you *are* connected to. (What
would you be connected to then?)
You'll need to log in to a different database to drop that database. In
psql you can ask what databases there are with '\l' and swich using '\c'.
I don't know the commands in phppgadmin, but they are there somewhere I'm
sure.
Daniel T. Staal
------------------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you are
expressly allowed to retransmit, quote, or otherwise use the contents for
non-commercial purposes. This copyright will expire 5 years after the
author's death, or in 30 years, whichever is longer, unless such a period
is in excess of local copyright law.
------------------------------------------------------------------------
------------------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you are
expressly allowed to retransmit, quote, or otherwise use the contents
for non-commercial purposes. This copyright will expire 5 years after
the author's death, or in 30 years, whichever is longer, unless such a
period is in excess of local copyright law.
------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-06-01 20:35:24 | Re: phppgadmin |
Previous Message | Daniel T. Staal | 2005-06-01 19:33:58 | Cursors from Java? |