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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
