Re: BUG #5272: PL/Python SELECT: return composite fields as dict, not str - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5272: PL/Python SELECT: return composite fields as dict, not str
Date
Msg-id 603c8f071001111831j5b05b57cs108d2792c390e26@mail.gmail.com
Whole thread Raw
In response to BUG #5272: PL/Python SELECT: return composite fields as dict, not str  ("Steve White" <swhite@aip.de>)
Responses Re: BUG #5272: PL/Python SELECT: return composite fields as dict, not str  (Steve White <swhite@aip.de>)
List pgsql-bugs
On Mon, Jan 11, 2010 at 11:41 AM, Steve White <swhite@aip.de> wrote:
> I see nothing in the documentation about this
> =A0 =A0 =A0 =A0http://www.postgresql.org/docs/8.4/static/plpython.html
> It only talks about passing composite types into and out of functions.
>
> This is an unpleasant discovery for those working to a deadline. =A0Perha=
ps a
> "limitations" section for the doc would be in order. =A0(You could also l=
ist
> the limitations of PL/Python regarding returning RECORD types.)

Maybe you could suggest some text, perhaps in the form of a context
diff against the current sgml files?

> But the best thing to do would be to fix it.

Doubtless.  Of course it will depend on whether anyone finds enough
round tuits.  Peter Eisentraut made some improvements to PL/python
array handling which will be in the next major release, but I am not
aware of anyone working on record types.  This is an all-volunteer
effort, so people tend to scratch their own itches.

> For backward compatibility, you might implement a switch that turns on the
> hierarchical interpretation of fields, and leave the current behaviour as
> the default.

I suspect we wouldn't bother with that.

...Robert

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: error after dropping column
Next
From: Thomas Specker
Date:
Subject: Re: Failed to run initdb - not resolved bug 5130