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
