Pgadmin - Column sys?

Author

Column sys?

Walter Haslbeck

2005-06-14, 3:24 am

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(nspo
wner) 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

Hiroshi Saito

2005-06-14, 3:24 am

Hi.

It is already Andreas fixed,
However, it was a 20050607.
http://archives.postgresql.org/pgad...06/msg00035.php
Will you try it by the fresher thing?

regards,
Hiroshi Saito

From: "Walter Haslbeck" <wh@hillerzentri.de>

> 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:

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere
" to majordomo@postgresql
.org)

Andreas Pflug

2005-06-14, 3:24 am

Hiroshi Saito wrote:
> Hi.
>
> It is already Andreas fixed,
> However, it was a 20050607.
> http://archives.postgresql.org/pgad...06/msg00035.php
> Will you try it by the fresher thing?

Sorry, no new snapshot available yet.
As a workaround, you can switch on "display system objects".

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Dave Page

2005-06-14, 3:24 am

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Andreas Pflug
> Sent: 14 June 2005 08:21
> To: Hiroshi Saito
> Cc: Walter Haslbeck; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Column sys?
>
> Hiroshi Saito wrote:
>
> Sorry, no new snapshot available yet.
> As a workaround, you can switch on "display system objects".

Speaking of which - did you notice we now have a new, easy-to-build
installer for Windows based on the open source Wix toolset? If you've
objection we can easily start producing snapshots using that.

/D

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Tino Wildenhain

2005-06-14, 3:24 am

Am Dienstag, den 14.06.2005, 08:32 +0100 schrieb Dave Page:

>
>
> Speaking of which - did you notice we now have a new, easy-to-build
> installer for Windows based on the open source Wix toolset? If you've
> objection we can easily start producing snapshots using that.
>
wow. might be an option for the database itself too?
I read a couple of install problems lately on the lists.
--
Tino Wildenhain <tino@wildenhain.de>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org

Dave Page

2005-06-14, 3:24 am

> -----Original Message-----
> From: Tino Wildenhain & #91;mailto:tino@wild
enhain.de]
> Sent: 14 June 2005 09:34
> To: Dave Page
> Cc: Andreas Pflug; Hiroshi Saito; Walter Haslbeck;
> pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Column sys?
>
> wow. might be an option for the database itself too?
> I read a couple of install problems lately on the lists.

We already wrote the db installer in Wix (that's the Wix project I cut
my teeth on). And out of the 100K+ downloads, I don't think a couple of
bug reports is too bad considering how complex that particular installer
is :-)

/D

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Tino Wildenhain

2005-06-14, 7:24 am

Am Dienstag, den 14.06.2005, 09:38 +0100 schrieb Dave Page:

>
>
> We already wrote the db installer in Wix (that's the Wix project I cut
> my teeth on). And out of the 100K+ downloads, I don't think a couple of
> bug reports is too bad considering how complex that particular installer
> is :-)

Ah ok. And I see there was no german involved in the naming of the
project *giggle* ;)

--
Tino Wildenhain <tino@wildenhain.de>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org

Sponsored Links