On 2006-08-17, Gerardo Herzig <[EMAIL PROTECTED]> wrote:
> Hi all, sory if this is kind of [OT], but cannot find the answer for
> this behaviour
>
Might try on a postgres mailing list. I'd say it is more
on topic there...
> You are now connected to database "sessions".
> sessions=# select * from
> getsessiondata('QQtEpLoKHnvbKGSpgJgYMPyCdHgXSi');
>
>
> getsessiondata
>
>
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> (dp0--ENTER--S---alucod-----ENTER--p1--ENTER--S---32009436-----ENTER--p2--ENTER--sS---respuestas_1-----ENTER--p3--ENTER--S---3-----ENTER--p4--ENTER--sS---respuestas_2-----ENTER--p5--ENTER--S---2-----ENTER--p6--ENTER--sS---respuestas_3-----ENTER--p7--ENTER--S---4-----ENTER--p8--ENTER--sS---submit-----ENTER--p9--ENTER--S---Responder-----ENTER--p10--ENTER--s.
> data = plpy.execute("SELECT * from dblink('dbname=sessions', 'select * from
> getsessiondata(\'\'%s\'\')') as t1(session_data name); " %
> session_id)[0]["session_data"];
> plpy.notice(data)
> """
> i got this
> NOTICE:
> ("'(dp0--ENTER--S---alucod-----ENTER--p1--ENTER--S---32009436-----'",)
Can you try just...
SELECT * from dblink('dbname=sessions', 'select * from
getsessiondata('QQtEpLoKHnvbKGSpgJgYMPyCdHgXSi');
> Im not even sure if this is a pickle, plpython nor postgresql issue
or a dblink issue?
--
http://mail.python.org/mailman/listinfo/python-list
