Re: process crash when a plpython function returns unicode - Mailing list pgsql-hackers

From Michael Fuhr
Subject Re: process crash when a plpython function returns unicode
Date
Msg-id 20050627141204.GA94894@winnie.fuhr.org
Whole thread Raw
In response to Re: process crash when a plpython function returns  (Tino Wildenhain <tino@wildenhain.de>)
Responses Re: process crash when a plpython function returns
List pgsql-hackers
On Sat, Jun 18, 2005 at 05:27:28PM +0200, Tino Wildenhain wrote:
> Am Samstag, den 18.06.2005, 08:41 -0600 schrieb Michael Fuhr:
> > 
> > I was going to submit a patch, but I don't know enough about the
> > Python API or how Python and PostgreSQL handle Unicode to know
> > whether adding that simple check is the appropriate solution (I was
> > planning to raise an error if PyObject_Str() returned NULL).  Can
> > anybody think of a better fix?
> 
> raise error would be a correct solution since this is what
> python does in this case:

I just submitted a patch that checks for NULL and raises an error
via PLy_elog().

> also in this context it would be helpful
> if sys.defaultencoding would be set to
> the database encoding so strings get encoded
> to utf-8 when postgres works in unicode mode
> rather then the default encoding of ascii.
> This could avoid most of the PyObject_Str()
> exeptions in the first place.

I haven't looked at doing that yet and probably won't before feature
freeze.  Gerrit van Dyk has expressed an interest in hacking on
PL/Python (he recently submitted a SETOF patch) so maybe he'll work
on it.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: contrib/rtree_gist into core system?
Next
From: strk
Date:
Subject: Re: accessing postgres conf from stored procedure