Обсуждение: Error: column "nsptablespace" does not exist

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_namespacensp         LEFT OUTER JOIN pg_tablespace ta on ta.oid=nsptablespace         LEFT OUTER JOIN pg_description
desON des.objoid=nsp.oid        ORDER BY 1, nspname
 

-- 
Greetings from Troels Arvin, Copenhagen, Denmark

Hi Troels

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Troels Arvin
> Sent: 13 November 2004 22:15
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Error: column "nsptablespace" does
> not exist
>
> 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

This has been fixed for RC2.

Regards, Dave.