BUG #4976: pgadmin - reconnect to drop database

Lists: pgsql-bugs
From: "Jim Michaels" <jmichae3(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4976: pgadmin - reconnect to drop database
Date: 2009-08-12 07:28:59
Message-ID: 200908120728.n7C7Sx4o079551@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4976
Logged by: Jim Michaels
Email address: jmichae3(at)yahoo(dot)com
PostgreSQL version: 8.4.0
Operating system: Windows XP Pro SP3
Description: pgadmin - reconnect to drop database
Details:

1. after some database activity outside and inside pgadmin 1.10.0 rev
7945:7946,
in order to drop a database, you must first disconnect and reconnect.
this should not be so.

2. After creating a database outside of pgadmin, clicking the refresh button
will not usually show the new database.

3. oftentimes, I cannot drop a table without disconnecting and
reconnecting.

in other words, the connection is stale and intermittently broken.


From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Jim Michaels <jmichae3(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4976: pgadmin - reconnect to drop database
Date: 2009-08-14 03:30:46
Message-ID: 603c8f070908132030xf130df7qf3e6e2d23fb2697a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On Wed, Aug 12, 2009 at 3:28 AM, Jim Michaels<jmichae3(at)yahoo(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      4976
> Logged by:          Jim Michaels
> Email address:      jmichae3(at)yahoo(dot)com
> PostgreSQL version: 8.4.0
> Operating system:   Windows XP Pro SP3
> Description:        pgadmin - reconnect to drop database
> Details:
>
> 1. after some database activity outside and inside pgadmin 1.10.0 rev
> 7945:7946,
> in order to drop a database, you must first disconnect and reconnect.
> this should not be so.
>
> 2. After creating a database outside of pgadmin, clicking the refresh button
> will not usually show the new database.
>
> 3. oftentimes, I cannot drop a table without disconnecting and
> reconnecting.
>
> in other words, the connection is stale and intermittently broken.

It sounds like you might need to contact the pgadmin folks about this.
A quick Google search suggests that you might want to start here:

http://www.pgadmin.org/support/

...Robert