Column sys?

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

Responses

Browse pgadmin-support by date

  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)