Hi! I've come back.
On Fri, Jun 01, 2012 at 10:06:15AM +0200, Tom Coetser <su...@ic...> wrote:
> On Thursday 31 May 2012 16:16:41 Oleg Broytman wrote:
> > Ok, found the problem - str() removes one level of backslashes so I have
> > to double backslashes once again. See the attached patch - it passes all
> > tests.
>
> When I use the new patch on my test case, after adding some extended
> characters to the pickle column and setting the encoding to utf-8 (see below),
> i get this error:
>
> ------------------------
> $ python pickleTest.py
> 1/QueryIns: INSERT INTO server (id, config, name) VALUES (1,
> E'\\\\200\\\\002}q\\\\001(U\\\\005otherq\\\\002X\\\\010\\\\000\\\\000\\\\000f\\\\303\\\\266\\\\303\\\\266barq\\\\003U\\\\006remoteq\\\\004\\\\211U\\\\003dnsq\\\\005}q\\\\006(U\\\\006domainq\\\\007U\\\\007foo.barq\\\\010U\\\\010hostnameq\\\\011NuU\\\\010servicesq\\\\012]q\\\\013(U\\\\003webq\\\\014U\\\\010databaseq\\\\015eU\\\\006loggerq\\\\016NU\\\\005portsq\\\\017K\\\\002u.'::bytea,
> 'foo')
Very strange. It seems I have to redouble backslashes in my case but
not in yours. Puzzled...
Oleg.
--
Oleg Broytman http://phdru.name/ ph...@ph...
Programmers don't die, they just GOSUB without RETURN.
|