Skip site navigation (1) Skip section navigation (2)

PGAdmin schema tracking a bit off...

From: "Jason Godden" <jasongodden(at)optushome(dot)com(dot)au>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: PGAdmin schema tracking a bit off...
Date: 2002-11-25 07:58:59
Message-ID: ICENJAGIJGIHMCEMFJGACEAGCBAA.jasongodden@optushome.com.au (view raw or flat)
Thread:
Lists: pgadmin-support
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


pgadmin-support by date

Next:From: Dave PageDate: 2002-11-25 10:40:41
Subject: Re: Connection & Crash Problem From Domain Users
Previous:From: Çagil SekerDate: 2002-11-25 07:44:06
Subject: Re: Windows Version of PostGreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group