RE: can't access table properties in 1_1_20

Hi Fred,

I'm away from a pc until thursday, so I can't fix anything till
then, but perhaps you can check some things for me.

- Does this happen with every table? What about pg_class
for example?

- Does the table have any checks, foreign keys etc. on it.

- If you switch on the definition pane, what sql is generated
for the table?

As for the pg_ objects, yes they are obsolete now. pgAdmin
(original) has an option on the Advanced menu to remove
them all a bit more easily.

I'd also like to hear any comments you may have about the
new program...

regards, Dave.

--------------Replied message--------------
Date: Tue, 21 Aug 2001 09:49:39 -0500
From: fcy(at)acm(dot)org
Sender: pgadmin-support-owner(at)postgresql(dot)org
To: pgadmin-support(at)postgresql(dot)org
Reply-To: fcy(at)acm(dot)org
Subject: [pgadmin-support] can't access table properties in
1_1_20
Message-ID: <20010821094939(dot)A1215(at)ontosys(dot)com>

When I try to access "properties" of a table, either via the
right-button menu or the toolbar button, I get an alert titled
"pgAdmin II Error" saying

An error has occured in pgAdmin II:frmTable.Initialize:
Number: 457
Description: This key is already associated with an element
of
this collection.

A "Table" dialog window comes up, but it has no content in the
various
fields.

This is happening with pgAdmin II version 1.1 build 20 on an NT
4 SP 6
machine, accessing a PostgreSQL 7.1.2 server hosted on an NT
Cygwin
system.

I have used the older version of pgAdmin on this same database,
and it
worked well -- no obvious problems. There are pgadmin_*
objects
(tables, functions, views) in the database left over from that older
pgadmin. I tried removing all those objects, thinking that they
might
be obsolete, but that made no difference.

--
Fred Yankowski fred(at)OntoSys(dot)com tel:
+1.630.879.1312
Principal Consultant www.OntoSys.com fax:
+1.630.879.1370
OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510,
USA

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster