pgsql: plpython: Add SPI cursor support

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: plpython: Add SPI cursor support
Date: 2011-12-05 17:56:47
Message-ID: E1RXcmV-0000n6-6u@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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

Browse pgsql-committers by date

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

Browse pgsql-hackers by date

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