From: | Walter Haslbeck <wh(at)hillerzentri(dot)de> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Column sys? |
Date: | 2005-06-14 06:19:43 |
Message-ID: | 42AE76FF.9080204@hillerzentri.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 Messagebox with "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 JOIN pg_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.oid
WHERE (nsp.nspname NOT 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
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2005-06-14 06:48:47 | Re: Column sys? |
Previous Message | Dave Page | 2005-06-10 07:19:31 | Re: DarwinPorts Portfile (Was Re: Pgadmin on OS x) |