Postgres Pro
Downloads
Home   >   mailing lists

Thread: phppgadmin

phppgadmin

From
Sean
Date:
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.

Sean

Re: phppgadmin

From
"Daniel T. Staal"
Date:

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

Re: phppgadmin

From
Tom Lane
Date:
"Daniel T. Staal" <DStaal@usa.net> writes:
>> 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.

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

I have some recollection that newer versions of phppgadmin make this
easier by automatically closing windows that are connected to the victim
database.  However I might be confusing this with pgAdmin, which is a
different tool altogether ... and then again my memory might be faulty
in the first place ...

            regards, tom lane

Re: phppgadmin

From
Sean
Date:
It doesn't look like my previous message got through.  So far I've been
unable delete my "open" database.  I don't see a way of disconnecting in
phpPgAdmin.

"Daniel T. Staal" <DStaal@usa.net> writes:

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

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

I have some recollection that newer versions of phppgadmin make this
easier by automatically closing windows that are connected to the victim
database.  However I might be confusing this with pgAdmin, which is a
different tool altogether ... and then again my memory might be faulty
in the first place ...

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly


.