On Sat, Aug 27, 2005 at 05:21:46PM +0400, Oleg Bartunov wrote: > This query works as expected: > # select name_qualified from place > where fts_index @@ to_tsquery('moscow'); > > This query (essentially the same as above) crashes: > # select name_qualified from place, to_tsquery('moscow') as query > where fts_index @@ query; > > When I disable bitmap scanning (set enable_bitmapscan=off) > second query works fine.
Disabling enable_bitmapscan causes my example to succeed, but when I do get the error I don't get a crash, and the same query without EXPLAIN succeeds: CREATE TABLE foo (x integer); CREATE INDEX foo_x_idx ON foo (x); CREATE VIEW fooview AS SELECT count(*) FROM foo WHERE x < 10; SET enable_bitmapscan TO on; SELECT * FROM fooview; count ------- 0 (1 row) EXPLAIN SELECT * FROM fooview; ERROR: bogus varno: 5 SET enable_bitmapscan TO off; EXPLAIN SELECT * FROM fooview; QUERY PLAN ------------------------------------------------------------------------------ Aggregate (cost=32.41..32.41 rows=1 width=0) -> Index Scan using foo_x_idx on foo (cost=0.00..30.63 rows=713 width=0) Index Cond: (x < 10) (3 rows) -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster