From: | "Jason Godden" <jasongodden(at)optushome(dot)com(dot)au> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | PGAdmin schema tracking a bit off... |
Date: | 2002-11-21 23:57:23 |
Message-ID: | ICENJAGIJGIHMCEMFJGAEEABCBAA.jasongodden@optushome.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All,
Don't know if anyone else has had this problem (I'm hoping someone else has
had this problem:)
If I create a second or third schema (PG7.3) in PgAdminII and then create a
view or table in the new schema and attempt to view the data the following
message results:
22/11/2002 07:51:05 - Error in pgAdmin
II:frmMain.mnuPopupViewData_Click: -2147467259 - ERROR: Relation "test"
does not exist
Looking at the logs it has executed:
22/11/2002 07:51:05 - SQL (fsd): SELECT count(*) AS count FROM "test"
When is should have executed:
22/11/2002 07:51:04 - SQL (fsd): SELECT count(*) AS rows FROM
sch_parking.test
.. which works fine.
If I use the generic 'public' schema everything is fine... (but ofcourse why
would I want to use schema's and put everthing into public? :)
I have enabled and disabled the auto row count on tables and views to no
success although I don't know how much effect this has (haven't bothered
looking at the source code yet...)
This happens regardless of whether it's a view or table. Is this a common
problem until 7.3 is at release stage? Or does the issue lie with
PGAdminII? (You guys have done a great job of this by the way!) I'm using
PGAdminII 1.4 and PostgreSQL 7.3 RC1.
Cheers,
Jason
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Lynch | 2002-11-22 01:05:27 | Re: crash help, pgsql 7.2.1 on RH7.3 |
Previous Message | Tom Lane | 2002-11-21 23:56:54 | Re: Query performanc issue - too many table? |