"Alexander Strotmann" <[EMAIL PROTECTED]> writes: > we have this table: > ... > and this view: > ... > So the view joins the upper table with another view
Another view? Don't you think you've left out a lot of information that would be needed for anyone trying to reproduce this failure? Please show the *full* definition of all tables and views involved. And, as already noted, "8.2" isn't enough information about which PG version you're running. If it's an early 8.2.x release and the other view involves any outer joins, then I could believe that this is explained by one of the outer join planning bugs we've already fixed ... but without any details that's only a wild guess. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs