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

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 (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-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

pgsql-hackers by date

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

pgsql-committers by date

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

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