plpython and pickle

[Lee Harr]

On 2006-08-17, Gerardo Herzig <gherzig at fmed.uba.ar> 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?