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

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl(at)postgresql(dot)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.