From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
---|---|
To: | Hannu Krosing <hannu(at)skype(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: plpython and bytea |
Date: | 2005-11-21 07:37:03 |
Message-ID: | 1132558623.19421.10.camel@Andrea.peacock.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 :)
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2005-11-21 07:59:38 | Re: Data directory on read-only media |
Previous Message | Josh Berkus | 2005-11-21 04:23:30 | Re: Data directory on read-only media |