Re: pgadmin 3.5 drop database fails because of active connection

On Sat, Nov 17, 2018 at 7:06 PM John Nowlan <JohnNowlan(at)cunet(dot)carleton(dot)ca>
wrote:

> *Version*
>
> 3.5
>
> *Copyright*
>
> Copyright 2013 - 2018, The pgAdmin Development Team
>
> *Python Version*
>
> 3.6.5 (v3.6.5:f59c0932b4, Mar 28 2018, 16:07:46) [MSC v.1900 32 bit
> (Intel)]
>
> *Flask Version*
>
> 0.12.4
>
> *Application Mode*
>
> Desktop
>
> *Current User*
>
> pgadmin4(at)pgadmin(dot)org
>
>
>
> - windows 10
>
> - desktop
>
>
>
> I try and click on a db in tree view and from menu select delete/drop
>
> - get msg:
> Error message <http://127.0.0.1:55663/browser/#collapseOne>
>
> ERROR: database "mah" is being accessed by other users DETAIL: There is 1
> other session using the database.
>
> - Appears selecting the db from tree view creates session,
> therefore always a session to db and unable to drop from gui
>
> This should not be the case.The database connection has been closed before
deleting it.
There should be another session (Ex: psql, query tool) which is creating
this problem. So, try to close all the sessions before deleting any
database from GUI.

>
>
>
>