Error in public and tables object

From: ferdinan firmansyah <mymand(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Error in public and tables object
Date: 2003-01-01 02:17:02
Message-ID: 20030101021702.4133.qmail@web14002.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Problems :
1. When I click public from pgAdmin I got this error
message :

An error has occured in pgadminII:frmMain.tvNamespace:
Number: -2147467259
Description: cache lookup for proc 3013562 failed

2. When I click certain tables from pgAdmin I got this
error message :

An error has occured in pgadminII:frmMain.tvTable:
Number: 457
Description: This key is already associated with an
element of this collection

1. What is the problem?
2. How can I fix the problem ?
3. I can't see view objects?
4. I can only see the checks and columns object of
those tables(problem no 2), I can't see other objects
(foreign keys, indexes, rules and trigger).
5. How can I see the list of indexes object of a
certain table without using pgAdmin?

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Browse pgsql-admin by date

  From Date Subject
Next Message Minghann Ho 2003-01-01 03:20:29 alter table TBL add constraint TBL_FK foreign key ... very slow
Previous Message Lamar Owen 2003-01-01 01:25:11 Re: postsgresql-dump not found in install