Re: phppgadmin

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