On Fri, Sep 09, 2005 at 02:35:07PM -0700, Bricklen Anderson wrote: > 8.1beta1, linux > > If I issue a query from a view with a WHERE condition, w/ EXPLAIN ANALYZE, I am > receiving an error: > > dev#EXPLAIN ANALYZE select sum(bytes) from user_bw where id=33897; > ERROR: bogus varno: 205 Search the archives for "bogus varno"; this sounds like the same bug that was fixed a couple of weeks ago. http://archives.postgresql.org/pgsql-committers/2005-08/msg00374.php Grab the latest code from CVS or wait until 8.1beta2 comes out. If you still get the problem, report it to pgsql-hackers. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster