Обсуждение: Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear
Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear
От
Peter Geoghegan
Дата:
Hello, 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. Are you aware of this problem? I only took a cursory glance at the recent mailing list archives. Regards, Peter Geoghegan
Re: Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear
От
Guillaume Lelarge
Дата:
Le 28/05/2010 13:07, Peter Geoghegan a écrit : > [...] > 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. > > Are you aware of this problem? I only took a cursory glance at the > recent mailing list archives. > We now are. It reproduce this on functions. I won't be surprise we have the same issue with triggers and views (they are the only objects that really implement the IsUpToDate() method). I added a ticket to remind me to work on this (http://code.pgadmin.org/trac/ticket/198). Thanks for your report, and sorry for the late answer. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Re: Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear
От
Guillaume Lelarge
Дата:
Le 31/05/2010 20:40, Guillaume Lelarge a écrit : > Le 28/05/2010 13:07, Peter Geoghegan a écrit : >> [...] >> 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. >> >> Are you aware of this problem? I only took a cursory glance at the >> recent mailing list archives. >> > > We now are. It reproduce this on functions. I won't be surprise we have > the same issue with triggers and views (they are the only objects that > really implement the IsUpToDate() method). > > I added a ticket to remind me to work on this > (http://code.pgadmin.org/trac/ticket/198). > > Thanks for your report, and sorry for the late answer. > OK, the bug should be fixed now. You can check that on pgAdmin 1.12beta when it'll be out. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Re: Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear
От
Peter Geoghegan
Дата:
> > OK, the bug should be fixed now. You can check that on pgAdmin 1.12beta > when it'll be out. Great, thanks -- Regards, Peter Geoghegan