Skip site navigation (1) Skip section navigation (2)

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

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/ ontrib/tablefunc/tablefunc.c rc/ ...
Date: 2003-03-09 02:19:14
Message-ID: 20030309021914.21575475AFF@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
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.


Responses

pgsql-committers by date

Next:From: Joe ConwayDate: 2003-03-09 02:49:12
Subject: Re: pgsql-server/ ontrib/tablefunc/tablefunc.c rc/ ...
Previous:From: Barry LindDate: 2003-03-08 06:09:37
Subject: pgsql-server/src/interfaces/jdbc/org/postgresq ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group