Re: pgadmin Bogus Varno: 3

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