plpython: Add SPI cursor support

Add a function plpy.cursor that is similar to plpy.execute but uses an
SPI cursor to avoid fetching the entire result set into memory.

Jan Urbański, reviewed by Steve Singer

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/89e850e6fda9e4e441712012abe971fe938d595a

Modified Files
--------------
doc/src/sgml/plpython.sgml                         |   81 +++
src/pl/plpython/expected/plpython_spi.out          |  151 +++++
.../plpython/expected/plpython_subtransaction.out  |   66 ++
.../expected/plpython_subtransaction_0.out         |   70 +++
.../expected/plpython_subtransaction_5.out         |   70 +++
src/pl/plpython/expected/plpython_test.out         |    6 +-
src/pl/plpython/plpython.c                         |  642 ++++++++++++++++++++
src/pl/plpython/sql/plpython_spi.sql               |  116 ++++
src/pl/plpython/sql/plpython_subtransaction.sql    |   52 ++
9 files changed, 1251 insertions(+), 3 deletions(-)

Responses

• Re: pgsql: plpython: Add SPI cursor support at 2011-12-05 18:11:54 from Bruce Momjian
• Re: [COMMITTERS] pgsql: plpython: Add SPI cursor support at 2011-12-06 18:23:30 from Tom Lane
• Re: pgsql: plpython: Add SPI cursor support at 2011-12-14 21:46:58 from Andrew Dunstan

pgsql-hackers by date

Next:	From: Peter Eisentraut	Date: 2011-12-05 17:58:07
	Subject: Re: plpython SPI cursors
Previous:	From: Tom Lane	Date: 2011-12-05 17:53:23
	Subject: Re: Inlining comparators as a performance optimisation

pgsql-committers by date

Next:	From: Bruce Momjian	Date: 2011-12-05 18:11:54
	Subject: Re: pgsql: plpython: Add SPI cursor support
Previous:	From: User Fxjr	Date: 2011-12-05 02:01:04
	Subject: npgsql - Npgsql2: Fixed "LOG: unexpected EOF on client connection"