plpython improvements

Started by Sven Suursohoover 19 years ago4 messageshackers
Jump to latest
#1Sven Suursoho
pg@spam.pri.ee

Hello,

As previous patch seems to be forgotten I send it again, updated against
current
HEAD.

Summary of changes:
* return SETOF as Python's sequence types (tuple, list) or using iterator
or
generator
* return composite types as sequence (tuple, list), mapping (dict) or class
(actually any object providing method __getattr__)
* named procedure arguments

Regression tests are also updated to include testing of new features and
existing tests to use named procedure parameters.

--
Sven Suursoho

Attachments:

plpython.patchtext/x-patch; name=plpython.patchDownload+1121-190
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Sven Suursoho (#1)
Re: [PATCHES] plpython improvements

Anyone in a position to review the pending plpython patch?
http://archives.postgresql.org/pgsql-patches/2006-08/msg00151.php

After that little fiasco with plperl I'm disinclined to apply anything
without review by somebody who's pretty familiar with the PL in
question ... and Python's not my language.

regards, tom lane

#3Michael Fuhr
mike@fuhr.org
In reply to: Tom Lane (#2)
Re: [PATCHES] plpython improvements

On Fri, Aug 18, 2006 at 04:27:23PM -0400, Tom Lane wrote:

Anyone in a position to review the pending plpython patch?
http://archives.postgresql.org/pgsql-patches/2006-08/msg00151.php

In several places the code does this:

so = PyObject_Str(value);
valuestr = PyString_AsString(so);

We've previously learned that calling PyString_AsString() without
checking the return value of PyObject_Str() can result in a
segmentation fault.

http://archives.postgresql.org/pgsql-committers/2005-07/msg00233.php

I haven't examined the current patch closely enough to know whether
PyObject_Str() can possibly return NULL, but several occurrences
of the above code snippet caught my eye because we had dealt with
it before.

--
Michael Fuhr

#4Andrew Dunstan
andrew@dunslane.net
In reply to: Tom Lane (#2)
Re: [PATCHES] plpython improvements

Tom Lane wrote:

Anyone in a position to review the pending plpython patch?
http://archives.postgresql.org/pgsql-patches/2006-08/msg00151.php

After that little fiasco with plperl I'm disinclined to apply anything
without review by somebody who's pretty familiar with the PL in
question ... and Python's not my language.

does it have docs?

cheers

andrew