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

sys column error

From: Diego Gil <diego(at)adminsa(dot)com>
To: PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: sys column error
Date: 2005-06-07 15:51:12
Message-ID: 1118159474.20510.6.camel@roadwarrior.adminsa.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hi,

I made a new build, after an svn checkout, and I am getting an error
with prevent me to open my databases:

ERROR: no existe la columna "sys" 

which means

ERROR: column "sys" doesn't exists.

Previous working version was dated JUN-01-2005.

log file says :


2005-06-07 12:45:20 STATUS : Obteniendo Esquemas detalles...
2005-06-07 12:45:20 QUERY  : Set query (mi_servidor:5432): SELECT CASE
WHEN nspname LIKE 'pg\_temp\_%%' THEN 1
             WHEN nsp.oid<17228 OR nspname like 'pg\_%' THEN 0
             ELSE 3 END AS nsptyp,
        nsp.nspname, 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_description des ON des.objoid=nsp.oid
 WHERE (nsp.nspname NOT LIKE 'pg\_%' AND nsp.nspname NOT in
('information_schema', sys)) ORDER BY 1, nspname
 2005-06-07 12:45:20 ERROR  : ERROR:  no existe la columna «sys»
 2005-06-07 12:45:26 STATUS : Obteniendo Esquemas detalles... (5,46 seg)

Thanks,
Diego.



Responses

pgadmin-hackers by date

Next:From: svnDate: 2005-06-07 15:56:14
Subject: SVN Commit by andreas: r4284 - trunk/pgadmin3/src/db
Previous:From: svnDate: 2005-06-07 15:48:36
Subject: SVN Commit by andreas: r4283 - branches/REL-1_2_0_PATCHES/pgadmin3/src/ui

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