Re: pgadmin Bogus Varno: 3

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

laurie(dot)burrow(at)powerconv(dot)alstom(dot)com wrote:
> I am using Pgadmin Version 1.2.0 (Nov 29 2004) as shipped with Postgres


> 2005-01-11 09:57:43 QUERY  : Set query (localhost:5433): SELECT c.oid,
> c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description,
> pg_get_viewdef(c.oid, true) AS definition
>   FROM pg_class c
>   LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and
> des.objsubid=0)
>  WHERE ((c.relhasrules AND (EXISTS (
>            SELECT r.rulename FROM pg_rewrite r
>             WHERE ((r.ev_class = c.oid)
>               AND (bpchar(r.ev_type) = '1'::bpchar)) ))) OR (c.relkind
> = 'v'::char))
>    AND relnamespace = 2200::oid
>  ORDER BY relname
> 2005-01-11 09:57:43 ERROR  : ERROR:  bogus varno: 3

That's a new one!
Please run that offending query interactively (you'll hopefully receive 
that error then too), and try to change it (e.g. restrict to a single 
view's oid) to find out what's happening. We might have to redirect you 
to pgsql-bugs, after we know more exactly the reason.

Try pg_get_viewdef(c.oid, false), to check if view reformatting code is 
the sinner.

Regards,
Andreas