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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
