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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-hackers by date

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