Re: Wish for an option to close a DB

Thanks, I'll remember it and have a try.

> -----Original Message-----
> From: Alexander Borkowski [mailto:alexander.borkowski@abri.une.edu.au]
> Sent: Dienstag, 18. Jänner 2005 23:42
> To: KÖPFERL Robert
> Cc: pgadmin-support
> Subject: Re: [pgadmin-support] Wish for an option to close a DB
>
>
> Hello,
>
> > we've got often the problem that we were working on a
> database just to drop
> > it afrerwarts and recreate it from the current developement
> schema. However
> > postgres denies to drop a DB until all sessions are closed.
> Since we were
> > working on it and pgAdmin has no db-specific option (or did
> we just oversee
> > it) to close a specific DB, we have to close the whole
> connection. This is
> > bad.
> > I whish myself an option in the context menu to detach a db.
>
> I second that wish. Here is what I found useful as a
> workaround: If you
> select the "Databases" item in the treeview and do a refresh (via
> hitting F5 or from the context menu item), pgAdmin will close all
> connections to that server _except_ for the one connection to the
> initial database for that server, i.e. you only have to disconnect if
> you drop the database listed as being the one pgAdmin connects to by
> default when connecting to this particular server.
>
> Cheers,
>
> Alex
>