Re: Wish for an option to close a DB - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Wish for an option to close a DB
Date
Msg-id 41FA4430.7000909@pse-consulting.de
Whole thread Raw
In response to Wish for an option to close a DB  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
List pgadmin-support
KÖPFERL Robert wrote:
> Hi,
> 
> 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.
> 
> And BUG: If I was working on a table or stored procedure, the dialog is
> still open and I close down the connection, pgAdmin does this. The dialogs
> still remain. After an event, reconnected or not, PgAdmin crashes  (Jan 14
> on w2k).

Yes, don't do that. This is a strong argument *not* to implement db 
disconnection, I'd expect even more frequent crashes.

Currently, we don't track which property dialog is open and using a 
specific connection. I've put that on TODO.txt.

Regards,
Andreas




pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: [Feature-Request] Pre-defined Select in SQL-Query
Next
From: Andreas Pflug
Date:
Subject: Re: Segmentation fault