cPickle and pgsql...damn!!

Gerardo Herzig -Departamento de Proyectos Especiales e Internet- Facultad de Medicina gherzig at fmed.uba.ar
Tue Jul 20 17:48:29 EDT 2004


Hi people, im having trouble when trying to UnPickle a 'pickled' field from a 
psql (7.3) field.

I just want:

>damnDict = {'foo' : 'bar'}
>serializedDict = cPickle.dumps(damnDict)
>print serializedDict
>'}q\x01U\x03fooq\x03barq\x03s.'
>pgconn.query('insert into TABLE values (%s)' % serializedDict)
>result = pgconn.query('select * from TABLE').getresult()[0]
>print result
>'}qx01Ux03fooqx03barqx03s.'
And....voila!! There is not the same piece of crap!!
When i try to unpickle it (and get the original damnDict) i got 'Cant find 
MARK' error msg. Maybe this is a PostgreSQL issue, but if someone have a 
clue....
Here is the data
Python 2.2
PostgreSQL 7.3
The field where i put the serialized data is a text field.

Thanks!
-- 
Gerardo Herzig
Departamento de Proyectos Especiales e Internet
Facultad de Medicina
U.B.A.



More information about the Python-list mailing list