[pgAdmin III] #198: Refreshing functions within the object browser causes them to disappear

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #198: Refreshing functions within the object browser causes them to disappear
Date: 2010-05-31 18:40:00
Message-ID: 056.8f2aedbcb41ab3bd480e9b9862361094@code.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

#198: Refreshing functions within the object browser causes them to disappear
-----------------------------+----------------------------------------------
Reporter: Peter Geoghegan | Owner: dpage
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: functions | Platform: all
-----------------------------+----------------------------------------------
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.

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/198>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2010-05-31 19:18:56 1.12 beta 2
Previous Message pgAdmin Trac 2010-05-31 17:52:49 [pgAdmin III] #197: copy/paste numeric fields