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