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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
