Added to TODO:

o Allow PL/python to composite types and result sets
once buggy assert-enabled versions of python can be detected$


Hannu Krosing wrote:
?hel kenal p?eval, N, 2006-05-04 kell 18:21, kirjutas Sven Suursoho:

Sun, 30 Apr 2006 19:14:28 +0300, Tom Lane <>:
"Sven Suursoho" <> writes:
Unfortunately, there is still one problem when using unpatched python,
caused by too aggressive assert.
I don't think we are going to be able to accept a patch that causes the
server to crash when using any but a bleeding-edge copy of Python.
Actually not bleeding-edge, but just version 2.4.x as distributed in
Fedora Core (and possibly in RHAS), which have assert() enabled in

The assert there is buggy (bug
Did complete rewrite for SETOF functions: now accepts any python object
for which iter(object) returns iterable object. In this way we don't have
to deal with specific containers but can use unified python iterator API.
It means that plpython is future-proof -- whenever python introduces new
container, stored procedures already can use those without recompiling
language handler.

Also integrated with regression tests and updated existing tests to use
named parameters.

When using python interpreter with asserts enabled, generators still
crash. But I don't think that we should drop this feature because of that.
1) this is someone else's bug, we are using documented API correctly
2) it doesn't concern majority of users because probably there is no
asserts in production packages (tested with gentoo, ubuntu, suse). This is
true even for older python versions that are not patched.
From reading the bug, it seems that older versions of python also don't
have this bug, only 2.4.
And after all, we can document using sets, lists, tuples, iterators etc
and explicitly state that returning generator is undefined.
I think that a less confusing way of saying it would be :

"Generators crash if python version used is 2.4.x and it is compiled
with asserts.

Currently only known linux distributions to distibute such
files are Fedora and possibly other RedHat distributions, while
Gentoo, Ubuntu and Suse are OK.

If you need to use generators on such a platform, compile your own
python from source and make sure that configure uses your version."

I think the patch should be commited so we can collect data about where
else the buggy version of python exists.

And if some buildfarm machines start crashing, python should be fixed


Bruce Momjian

+ If your life is a hard drive, Christ can be your backup. +

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 28 of 36 | next ›
Discussion Overview
grouppgsql-patches @
postedApr 15, '06 at 3:24p
activeSep 2, '06 at 12:30p



site design / logo © 2018 Grokbase