plpython and bytea

From: Hannu Krosing <hannu(at)skype(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: plpython and bytea
Date: 2005-11-21 00:11:48
Message-ID: 1132531909.27676.12.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)skype(dot)net>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Fuhr 2005-11-21 00:59:43 Re: Plan chosen for PQexecParams
Previous Message Tom Lane 2005-11-20 22:21:03 Re: Plan chosen for PQexecParams