Thread: Error column "sys" does not exist

Error column "sys" does not exist

From
Peter Fein
Date:
On logging in from PGAdmin over SSL, one of my fellow developers gets
the following message:

Error column "sys" does not exist

He can see a list of databases, but no schemas.  I'm not able to
replicate the problem.  TIA.

--Pete

--
Peter Fein                 pfein@pobox.com                 773-575-0694

Basically, if you're not a utopianist, you're a schmuck. -J. Feldman

Re: Error column "sys" does not exist

From
Peter Fein
Date:
Peter Fein wrote:
> On logging in from PGAdmin over SSL, one of my fellow developers gets
> the following message:
>
> Error column "sys" does not exist
>
> He can see a list of databases, but no schemas.  I'm not able to
> replicate the problem.  TIA.

Solved. From my coworker:

I checked "System objects" in the Display menu of pgadmin3 and it
worked, no more "sys" error and I can see the Schemas now.
I got the idea from this post:
http://www.mail-archive.com/pgadmin-support@postgresql.org/msg04140.html

--
Peter Fein                 pfein@pobox.com                 773-575-0694

Basically, if you're not a utopianist, you're a schmuck. -J. Feldman