From: | Troels Arvin <troels(at)arvin(dot)dk> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Error: column "nsptablespace" does not exist |
Date: | 2004-11-13 22:14:36 |
Message-ID: | pan.2004.11.13.22.14.29.111930@arvin.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello,
With RC1 and a PostgreSQL installation based on a rather fresh PosgreSQL
cvs HEAD checkout, I get the following error message when pgadmin connects
to the DBMS:
column "nsptablespace" does not exist
The error is repeated a couple of times. After this, the object tree is
rather empty: It only contains "Casts", "Languages", and an empty
"Schemas".
The SQL statement which seems to trigger the error message:
SELECT CASE WHEN nspname LIKE 'pg\_temp\_%%' THEN 1
WHEN nsp.oid<17228 OR nspname like 'pg\_%' THEN 0
ELSE 2 END AS nsptyp,
nsp.nspname, spcname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner, nspacl, description, has_schema_privilege(nsp.oid, 'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_tablespace ta on ta.oid=nsptablespace
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
--
Greetings from Troels Arvin, Copenhagen, Denmark
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-11-13 22:50:20 | Re: Error: column "nsptablespace" does not exist |
Previous Message | Dave Page | 2004-11-12 22:24:45 | Re: pgadmin3 1.2.0 rc1 windows |