plpython and bytea - Mailing list pgsql-hackers

From Hannu Krosing
Subject plpython and bytea
Date
Msg-id 1132531909.27676.12.camel@fuji.krosing.net
Whole thread Raw
Responses Re: plpython and bytea  (Tino Wildenhain <tino@wildenhain.de>)
Re: plpython and bytea  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
Hi

It seems that plpython is unable to return bytea string when it contains
NUL bytes:

hannu=# CREATE OR REPLACE FUNCTION get_bytea_with_nul() RETURNS bytea AS
'
return ''aa\\0bb''
' LANGUAGE plpythonu SECURITY DEFINER;

hannu=# select get_bytea_with_nul();get_bytea_with_nul
--------------------aa
(1 row)


probably related to plpythons way of generating return value via
converting python objcet to its string representation and then letting
postgres's input func to convert it back.


Btw, does anyone know where Andrew Bosma (the original author of
plpython) is ? 

I would probably have a paid job improving an opensource project for
him :)


-- 
Hannu Krosing <hannu@skype.net>



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Plan chosen for PQexecParams
Next
From: Michael Fuhr
Date:
Subject: Re: Plan chosen for PQexecParams