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. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
