Re: PostgreSQL warnings filling up the logs with PickleCol
Oleg Broytman <[email protected]>
| Newsgroups | gmane.comp.python.sqlobject |
|---|---|
| Message-ID | <[email protected]> |
Hi! I've come back. On Fri, Jun 01, 2012 at 10:06:15AM +0200, Tom Coetser <[email protected]> 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/ [email protected] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/