Re: pgsql: plpython: Add SPI cursor support

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>

To: Peter Eisentraut <peter_e@gmx.net>

Cc: pgsql-committers@postgresql.org, Jan Urbański <wulczer@wulczer.org>, Steve Singer <ssinger@ca.afilias.info>

Date: 2011-12-14T21:46:58Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

plpython: Add SPI cursor support
- 89e850e6fda9 9.2.0 cited

On 12/05/2011 12:56 PM, Peter Eisentraut wrote:
> 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
>
>

This commit apparently caused a problem on buildfarm narwhal, which has 
been failing for 8 days without anyone paying attention. See 
<http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=narwhal&dt=2011-12-14%2017%3A00%3A02>:

    plpython.c:3163: error: initializer element is not constant
    plpython.c:3163: error: (near initialization for `PLy_CursorType.tp_iter')
    make[3]: *** [plpython.o] Error 1

Can someone please investigate?

cheers

andrew