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