pgsql-server/src backend/optimizer/prep/prepjo ...

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@postgresql.org    03/02/10 12:08:50

Modified files:
    src/backend/optimizer/prep: prepjointree.c
    src/test/regress/expected: join.out
    src/test/regress/sql: join.sql

Log message:
    Fix thinko in new logic about pushing down non-nullability constraints:
    constraints appearing in outer-join qualification clauses are restricted
    as to when and where they can be pushed down.  Add regression test
    to catch future errors in this area.