Re: [SQLObject] PostgreSQL warnings filling up the logs with PickleCol

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.