Re: plpython and bytea

Am Montag, den 21.11.2005, 02:11 +0200 schrieb Hannu Krosing:
> 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.

Did you also try:

http://python.projects.postgresql.org/project/be.html

? Afaic it works a little different.

> 
> 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 :)
> 
>