Re: BUG #4106: WHERE - clause in view works only sometimes - Mailing list pgsql-bugs

Alexander Strotmann wrote:
> PostgreSQL version: 8.2

Which version, exactly? Though I don't remember any changes that would
explain this, make sure you run the latest minor version, which is 8.2.7
at the moment.

> we get sometimes results where 'bis' is not NULL! But it is not
> deterministic because in about 80% of request times the result is correct.

Do you get the same results if you run the "SELECT * FROM
benutzer_mit_rolle_vw" query directly from psql? What does EXPLAIN
ANALYZE say?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com