Thread: [pgAdmin III] #198: Refreshing functions within the object browser causes them to disappear
[pgAdmin III] #198: Refreshing functions within the object browser causes them to disappear
From
"pgAdmin Trac"
Date:
#198: Refreshing functions within the object browser causes them to disappear
-----------------------------+----------------------------------------------
Reporter: Peter Geoghegan | Owner: dpage
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: functions | Platform: all
-----------------------------+----------------------------------------------
I'm seeing what appears to be a bug on 1.10.3 (standard windows package),
on my windows XP SP3 machine. None of this behaviour can be reproduced
with 1.10.2. We're using the EDB windows binaries of postgres, version
8.4.3.
The second and subsequent times I apply changes to a function, I
invariably see a messagebox that says:
---------------------------
Overwrite changes?
---------------------------
The object has been changed by another user. Do you wish to continue
to to try to update it?
---------------------------
Yes No
---------------------------
In addition, if I refresh any individual function (of which there are
hundreds) within the object browser, it disappears. I can subsequently
refresh all functions, and my missing functions re-appear. I guess PgAdmin
stores the oid of functions internally, and cannot find objects of that
oid or somesuch when individual functions are refreshed. I've been meaning
to hack the pgadmin source code for some time now, but haven't gotten
around to it yet.
I hesitate to produce a test case (which I guess would take the form of a
schema only dump), because this database is, I'm afraid, commercially
sensitive.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/198>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: [pgAdmin III] #198: Refreshing functions within the object browser causes them to disappear
From
"pgAdmin Trac"
Date:
#198: Refreshing functions within the object browser causes them to disappear
-----------------------------+----------------------------------------------
Reporter: Peter Geoghegan | Owner: gleu
Type: bug | Status: assigned
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: functions | Platform: all
-----------------------------+----------------------------------------------
Changes (by gleu):
* owner: dpage => gleu
* status: new => assigned
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/198#comment:1>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: [pgAdmin III] #198: Refreshing functions within the object browser causes them to disappear
From
"pgAdmin Trac"
Date:
#198: Refreshing functions within the object browser causes them to disappear
------------------------------+---------------------------------------------
Reporter: Peter Geoghegan | Owner: gleu
Type: bug | Status: closed
Priority: minor | Milestone: 1.10.4
Component: pgadmin | Version: 1.10
Resolution: fixed | Keywords: functions
Platform: all |
------------------------------+---------------------------------------------
Changes (by gleu):
* status: assigned => closed
* resolution: => fixed
* milestone: => 1.10.4
Comment:
Fixed in r8402 and r8404.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/198#comment:2>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: [pgAdmin III] #198: Refreshing functions still causes them to disappear. (was: Refreshing functions within the object browser causes them to disappear)
From
"pgAdmin Trac"
Date:
#198: Refreshing functions still causes them to disappear.
------------------------------+---------------------------------------------
Reporter: Peter Geoghegan | Owner: gleu
Type: bug | Status: reopened
Priority: minor | Milestone: 1.10.4
Component: pgadmin | Version: 1.10
Resolution: | Keywords: functions
Platform: all |
------------------------------+---------------------------------------------
Changes (by brsa):
* status: closed => reopened
* resolution: fixed =>
Comment:
In pgadmin 1.12beta3 the problem is still present: "if I refresh any
individual function (of which there are hundreds) within the object
browser, it disappears."
- Does not happen with other collections, only with functions
Hint: I suspect the bug has been with the fix for ticket #177 (crash on F5
after "ALTER FUNCTION test() SET SCHEMA foo;"). Only now, F5 makes the
selected function disappear_every_ time instead of when it actually has
disappeared.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/198#comment:3>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: [pgAdmin III] #198: Refreshing functions still causes them to disappear.
From
"pgAdmin Trac"
Date:
#198: Refreshing functions still causes them to disappear.
------------------------------+---------------------------------------------
Reporter: Peter Geoghegan | Owner: gleu
Type: bug | Status: reopened
Priority: minor | Milestone: 1.12
Component: pgadmin | Version: trunk
Resolution: | Keywords: functions
Platform: all |
------------------------------+---------------------------------------------
Changes (by brsa):
* version: 1.10 => trunk
* milestone: 1.10.4 => 1.12
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/198#comment:4>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: Re: [pgAdmin III] #198: Refreshing functions still causes them to disappear.
From
Guillaume Lelarge
Date:
Le 12/07/2010 03:03, pgAdmin Trac a écrit : > #198: Refreshing functions still causes them to disappear. > ------------------------------+--------------------------------------------- > Reporter: Peter Geoghegan | Owner: gleu > Type: bug | Status: reopened > Priority: minor | Milestone: 1.12 > Component: pgadmin | Version: trunk > Resolution: | Keywords: functions > Platform: all | > ------------------------------+--------------------------------------------- > Changes (by brsa): > > * version: 1.10 => trunk > * milestone: 1.10.4 => 1.12 > Please don't change the version and milestone of a closed item. You can reopen a closed item if you found that it still doesn't work. If it doesn't work on trunk, just say so on the ticket by reopening it and add a comment. (part of the reason not to change the version and milestone is that we use them to know all bugfixes of a milestone. So, even if it is fixed in the bugfix release, you should not change the milestone and the version) -- Guillaume http://www.postgresql.fr http://dalibo.com
Re: [pgAdmin III] #198: Refreshing functions still causes them to disappear.
From
"pgAdmin Trac"
Date:
#198: Refreshing functions still causes them to disappear.
------------------------------+---------------------------------------------
Reporter: Peter Geoghegan | Owner: gleu
Type: bug | Status: reopened
Priority: minor | Milestone: 1.10.4
Component: pgadmin | Version: 1.10
Resolution: | Keywords: functions
Platform: all |
------------------------------+---------------------------------------------
Changes (by gleu):
* version: trunk => 1.10
* milestone: 1.12 => 1.10.4
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/198#comment:5>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: [pgAdmin III] #198: Refreshing functions still causes them to disappear.
From
"pgAdmin Trac"
Date:
#198: Refreshing functions still causes them to disappear.
------------------------------+---------------------------------------------
Reporter: Peter Geoghegan | Owner: gleu
Type: bug | Status: closed
Priority: minor | Milestone: 1.10.4
Component: pgadmin | Version: 1.10
Resolution: fixed | Keywords: functions
Platform: all |
------------------------------+---------------------------------------------
Changes (by dpage):
* status: reopened => closed
* resolution: => fixed
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/198#comment:6>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: Re: [pgAdmin III] #198: Refreshing functions still causes them to disappear. (was: Refreshing functions within the object browser causes them to disappear)
From
Dave Page
Date:
Fixed in SVN. On Mon, Jul 12, 2010 at 2:03 AM, pgAdmin Trac <trac@code.pgadmin.org> wrote: > #198: Refreshing functions still causes them to disappear. > ------------------------------+--------------------------------------------- > Reporter: Peter Geoghegan | Owner: gleu > Type: bug | Status: reopened > Priority: minor | Milestone: 1.10.4 > Component: pgadmin | Version: 1.10 > Resolution: | Keywords: functions > Platform: all | > ------------------------------+--------------------------------------------- > Changes (by brsa): > > * status: closed => reopened > * resolution: fixed => > > > Comment: > > In pgadmin 1.12beta3 the problem is still present: "if I refresh any > individual function (of which there are hundreds) within the object > browser, it disappears." > > - Does not happen with other collections, only with functions > > Hint: I suspect the bug has been with the fix for ticket #177 (crash on F5 > after "ALTER FUNCTION test() SET SCHEMA foo;"). Only now, F5 makes the > selected function disappear_every_ time instead of when it actually has > disappeared. > > -- > Ticket URL: <http://code.pgadmin.org/trac/ticket/198#comment:3> > pgAdmin III <http://code.pgadmin.org/trac/> > pgAdmin III > > -- > Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-hackers > -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company
Re: [pgAdmin III] #198: Refreshing functions still causes them to disappear.
From
"pgAdmin Trac"
Date:
#198: Refreshing functions still causes them to disappear.
------------------------------+---------------------------------------------
Reporter: Peter Geoghegan | Owner: gleu
Type: bug | Status: closed
Priority: minor | Milestone: 1.10.4
Component: pgadmin | Version: 1.10
Resolution: fixed | Keywords: functions
Platform: all |
------------------------------+---------------------------------------------
Comment(by gleu):
Fixed in r8464 and r8465.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/198#comment:7>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III