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.
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 |