pgsql-server/ ontrib/tablefunc/tablefunc.c rc/ ...

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@postgresql.org    03/03/08 21:19:14

Modified files:
    contrib/tablefunc: tablefunc.c
    src/backend/executor: execQual.c nodeMaterial.c
    src/backend/utils/sort: tuplestore.c
    src/include/nodes: execnodes.h
    src/include/utils: tuplestore.h
    src/pl/plpgsql/src: pl_exec.c

Log message:
    Revise tuplestore and nodeMaterial so that we don't have to read the
    entire contents of the subplan into the tuplestore before we can return
    any tuples.  Instead, the tuplestore holds what we've already read, and
    we fetch additional rows from the subplan as needed.  Random access to
    the previously-read rows works with the tuplestore, and doesn't affect
    the state of the partially-read subplan.  This is a step towards fixing
    the problems with cursors over complex queries --- we don't want to
    stick in Materialize nodes if they'll prevent quick startup for a cursor.