Column sys?
От | Walter Haslbeck |
---|---|
Тема | Column sys? |
Дата | |
Msg-id | 42AE76FF.9080204@hillerzentri.de обсуждение исходный текст |
Список | pgadmin-support |
Hello, I'v installed the latest win32 binary snapshot (20050603). When I try to connect to a remote 8.0.3 DB, I get the Messageboxwith "ERROR: column "sys" does not exist". The DB logfile looks like: ====================================================================== 2005-06-14 08:15:30 CEST postgres amg [2047] idle :LOG: statement: SELECT lan.oid, lan.lanname, lanpltrusted, lanacl, hp.proname as lanproc, vp.proname as lanval, description FROM pg_language lan JOIN pg_proc hp on hp.oid=lanplcallfoid LEFT OUTER JOINpg_proc vp on vp.oid=lanvalidator LEFT OUTER JOIN pg_description des ON des.objoid=lan.oid AND des.objsubid=0 WHERE lanispl IS TRUE ORDER BY lanname 2005-06-14 08:15:30 CEST postgres amg [2047] idle :LOG: statement: SELECT nspname FROM pg_namespace nsp JOIN pg_proc pr ON pronamespace=nsp.oid WHERE proname IN ('slonyversion') 2005-06-14 08:15:30 CEST postgres amg [2047] idle :LOG: statement: 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.oidWHERE (nsp.nspnameNOT LIKE 'pg\_%' AND nsp.nspname NOT in ('information_schema', sys)) ORDER BY 1, nspname 2005-06-14 08:15:30 CEST postgres amg [2047] SELECT :ERROR: column "sys" does not exist ====================================================================== Walter
В списке pgadmin-support по дате отправления: