From aa60eecc37c1bbb934079bf5234fba3e3879873d Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 9 Mar 2003 02:19:13 +0000 Subject: 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. --- contrib/tablefunc/tablefunc.c | 4 ---- 1 file changed, 4 deletions(-) (limited to 'contrib/tablefunc') diff --git a/contrib/tablefunc/tablefunc.c b/contrib/tablefunc/tablefunc.c index d5db3ceed7..6b502dda00 100644 --- a/contrib/tablefunc/tablefunc.c +++ b/contrib/tablefunc/tablefunc.c @@ -743,10 +743,6 @@ connectby(char *relname, SPI_finish(); - oldcontext = MemoryContextSwitchTo(per_query_ctx); - tuplestore_donestoring(tupstore); - MemoryContextSwitchTo(oldcontext); - return tupstore; } -- cgit v1.2.1