Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear
Date: 2010-05-28 11:07:34
Message-ID: AANLkTiktH3YMsQQVZrRsVRV__ouR72zu64yTymNqPrLJ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2010-05-31 18:36:44 Re: pgAdmin svn 8390 copy/paste numeric fields
Previous Message Fernando Hevia 2010-05-28 00:13:15 Re: strange select issue