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

> -----Original Message-----
> From: Alexander Borkowski [mailto:[EMAIL PROTECTED]
> 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
> 

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to