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

Error: column "nsptablespace" does not exist

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 (view raw or flat)
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



pgadmin-support by date

Next:From: Dave PageDate: 2004-11-13 22:50:20
Subject: Re: Error: column "nsptablespace" does not exist
Previous:From: Dave PageDate: 2004-11-12 22:24:45
Subject: Re: pgadmin3 1.2.0 rc1 windows

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