Re: An error has occurred in pgAdmin II:frmMain.tvDatabases: - Mailing list pgadmin-support

-----Original Message-----
From: Johnson, Shaunn [mailto:SJohnson6@bcbsm.com]
Sent: 24 September 2002 19:12
To: Dave Page
Subject: An error has occurred in pgAdmin II:frmMain.tvDatabases:

--Dave:

--I apologize for emailing outside of the mail list, but
--I need some information regarding pgAdminII and the
--errors my users are getting.

--I'm running PostgreSQL 7.2.1 on RedHat Linux 7.2 kernel 2.4.7-10
--and pgAdmin 1.2.0 / 1.3.82-Dev respectively.

--I am getting the following errors:

[error 1]

pgAdmin:
Number 457
Description: This key is already associated with an element of
this collection

[/error 1]

--

[error 2]

An error has occurred in pgAdminII: frmMain.tvTable
Number: -2147217887
Description: Multiple-step OLD DB operation generated errors.  Check
OLE DB status value, if available.  No work was done.

[/error 2]

--When I connect to the database.  I am only able to see a
--few tables with pgAdminII ver. 1.2.0 and NO tables with
--version 1.3.82-Dev, only Languages and Schema icons.

--Also, I visited the cvs site and downloaded the tarballs
--for the program and moved the binaries / dll from their
--original location and copied in the new versions (this
--is for version 1.3.82 only so far ...)

--I have also generated a log file (sent as an attachment)
--to see what's going on.

--Is there something that I should be doing or have I missed
--something?  What does the error mean and how can I fix
--this?

--Apologies and thanks!

-X

-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Wednesday, July 17, 2002 12:16 PM
To: Paul Wehr
Cc: Johnson, Shaunn
Subject: RE: [pgadmin-support] An error has occurred in pgAdmin
II:frmMain.tvDatabases:

Hi Paul,

If the problem is anything like I suspect, then a dump/reload may well
cure it. pgAdmin is falling over when it populates it's cache of object
comments from pg_description - my guess is that somehow there is a
duplicate objoid in there that is giving the error when pgAdmin adds the
second one to the collection. Regarding Tom's comment about signed OIDs,
pgAdmin (in that part of the code anyway) treats them as strings anyway,
so sign is not an issue.

wrt your colleagues comments about people actually using pgAdmin II, as
far as we can guess it is the most popular gui interface for PostgreSQL
there is :-) and is *definately* the most comprehensive. Version 1.2.0
has been downloaded 29683 time to date (it was released in Feruary iirc)
and 1.3.60 1966 times. Obviously some of those users didn't continue to
use it, but I know for sure that many of them downloaded one copy for
them and their colleagues.

Anyhoo, feel free to email me again when if you continue to have
problems.

Regards, Dave.

[snip the rest]