Error when deleting multiple databases: "Maintenance database can't be dropped."

From: Daniel Hahler <genml+pgadmin-support(at)thequod(dot)de>
To: pgadmin-support(at)postgresql(dot)org
Subject: Error when deleting multiple databases: "Maintenance database can't be dropped."
Date: 2015-01-18 16:01:43
Message-ID: 54BBD8E7.1060509@thequod.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

When selecting multiple databases (via the "Properties" tab) and trying to
delete them, only the first one gets deleted, and then an error pops up.

The question:

Drop multiple objects?
Are you sure you wish to drop multiple objects?

The error:

Dropping database not allowed
Maintenance database can't be dropped.

The "maintenance database" is not selected.

This is with pgadmin3 1.20.0-1 from Debian (the experimental repo), but
happens with 1.18.1-3, too.

The system is Ubuntu 14.04.

I am using libwxgtk3.0-0=3.0.2-1 and libwxbase3.0-0=3.0.2-1 (upgraded for
pgadmin3 1.20).

I think it might be related to having installed the postgresql-contrib package
and using the "Fix it!" button from the wizard that recommends this when
selecting the "postgres" database.
If I remember correctly, this used to work before - and I've suspected it to
be a regression in 1.20 (which I've just upgraded to also), but then the bug
is now also there with 1.18.

Thanks,
Daniel.

--
http://daniel.hahler.de/

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2015-01-19 08:56:25 Re: Is the "x ms" info reliable?
Previous Message Daniel Hahler 2015-01-18 15:58:04 Error when deleting multiple databases: "Maintenance database can't be dropped."