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