BUG #5171: Composite type with array does not translate in plpythonu
The following bug has been logged online:
Bug reference: 5171
Logged by: Jason
Email address: jason@beanfield.com
PostgreSQL version: 8.4
Operating system: FreeBSD
Description: Composite type with array does not translate in
plpythonu
Details:
When I have a plpythonu function returning a composite type that has an
array column, the function does not work when I try to return a list for
that column.
create type test_array as (
col1 text[]
);
create function return_array(val1 text, val2 text) returns test_array
as $$
return {'col1': [val1, val2]}
$$ language plpythonu;
select return_array('test1','test2')
ERROR: missing dimension value
********** Error **********
ERROR: missing dimension value
SQL state: 22P02
On fre, 2009-11-06 at 17:29 +0000, Jason wrote:
When I have a plpythonu function returning a composite type that has an
array column, the function does not work when I try to return a list for
that column.
There is a patch proposed to address that in 8.5, but before that,
arrays are pretty much not supported in plpythonu.
On Sat, Nov 7, 2009 at 5:23 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
On fre, 2009-11-06 at 17:29 +0000, Jason wrote:
When I have a plpythonu function returning a composite type that has an
array column, the function does not work when I try to return a list for
that column.There is a patch proposed to address that in 8.5, but before that,
arrays are pretty much not supported in plpythonu.
Is this at all related to bug #5128?
...Robert
On Sun, 2009-11-08 at 16:33 -0500, Robert Haas wrote:
On Sat, Nov 7, 2009 at 5:23 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
On fre, 2009-11-06 at 17:29 +0000, Jason wrote:
When I have a plpythonu function returning a composite type that has an
array column, the function does not work when I try to return a list for
that column.There is a patch proposed to address that in 8.5, but before that,
arrays are pretty much not supported in plpythonu.Is this at all related to bug #5128?
It's in the same area, but fixing one won't fix the other, I think.
On lör, 2009-11-07 at 12:23 +0200, Peter Eisentraut wrote:
On fre, 2009-11-06 at 17:29 +0000, Jason wrote:
When I have a plpythonu function returning a composite type that has an
array column, the function does not work when I try to return a list for
that column.There is a patch proposed to address that in 8.5, but before that,
arrays are pretty much not supported in plpythonu.
Btw., I just checked out your example against said patch and it works.
So something to look forward to ... ;-)