Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear - Mailing list pgadmin-support

From Peter Geoghegan
Subject Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear
Date
Msg-id AANLkTiktH3YMsQQVZrRsVRV__ouR72zu64yTymNqPrLJ@mail.gmail.com
Whole thread Raw
Responses Re: Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
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


pgadmin-support by date:

Previous
From: Fernando Hevia
Date:
Subject: Re: strange select issue
Next
From: Guillaume Lelarge
Date:
Subject: Re: pgAdmin svn 8390 copy/paste numeric fields