I don't think SA should do anything about it, just pointing it out. I can't switch to 2.0 because of breaking changes. I think it was a change from mx.DateTime to Python's datetime module. A positive move, but still breaking.
Randall Michael Bayer wrote: > even the psycopg site now says, "psycopg 2.0, the one you shall use". > > On Jun 27, 2006, at 3:34 PM, Randall Smith wrote: > > >>I'm having the same problem with psycopg 1.1.18. I'm betting it's >>psycopg. >> >>Randall >> >>Gambit wrote: >> >>>Hey All, >>> >>>This really looks exactly like the unicode problems I was having. >>> http://www.sqlalchemy.org/trac/ticket/86 >>> >>>Are you using psycopg1 or psycopg2? Tried convert_unicode? Test >>>case passes >>>using psycopg2 in 1419. >>>-G >>> >>>On Tuesday, May 9, 2006, 2:05:19 AM, you wrote: >>> >>> >>>>Dennis, >>> >>> >>>>FWIW, Your test script runs ok for me with sqlite and the latest svn >>>>trunk. You might want try running it with the trunk+PG. >>> >>> >>> >>>>Sean >>> >>> >>> >>>>On Mon, 2006-05-08 at 16:45 -0600, Dennis Muhlestein wrote: >>>> >>>> >>>>>On 5/8/06, Michael Bayer <[EMAIL PROTECTED]> wrote: >>>>> im not able to reproduce this problem, i can send unicode() >>>>> into >>>>> get_by or SQL constructs directly no problem. i also dont >>>>> immediately see anything that could cause it to construe a >>>>> unicode >>>>> string as anything other than a literal value (unless the >>>>> unicode() >>>>> function on your end is being clobered by something?) >>>>>can you >>>>> attach >>>>> a fully working test case ? >>>>> >>>>>I'm using Postgresql 8.1.3 on Linux. The attached test case >>>>>produces >>>>>the following output on both of my machines: >>>>> >>>>>____SNIP_____ >>>>> >>>>> >>>>>>python test.py >>>>> >>>>>working: dennis >>>>>Traceback (most recent call last): >>>>> File "test.py", line 30, in ? >>>>> t=Test.get_by(username=unicode('dennis')) >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/mapper.py", >>>>>line >>>>>258, in get_by >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/query.py", >>>>>line >>>>>58, in get_by >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/query.py", >>>>>line >>>>>137, in select_whereclause >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/query.py", >>>>>line >>>>>213, in _select_statement >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 473, in >>>>>execute >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 378, in >>>>>execute >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 355, in >>>>>execute >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line >>>>>646, in >>>>>execute_compiled >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line >>>>>641, in >>>>>proxy >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line >>>>>692, in >>>>>execute >>>>> File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line >>>>>712, in >>>>>_execute >>>>>sqlalchemy.exceptions.SQLError: (ProgrammingError) ERROR: column >>>>>"dennis" does not exist >>>>> >>>>>SELECT test.username AS test_username, test.id AS test_id >>>>>FROM test >>>>>WHERE test.username = dennis >>>>>LIMIT 1 'SELECT test.username AS test_username, test.id AS test_id >>>>>\nFROM test \nWHERE test.username = %(test_username)s \n LIMIT >>>>>1' {'test_username': u'dennis'} >>>>>_____END SNIP_________ >>>>> >>>>>Let me know if you need any additional information about my >>>>>environment or library versions. (SQLAlchemy 0.1.7) >>>>> >>>>>Thanks >>>>>-Dennis >>> >>> >>> >>> >>>>------------------------------------------------------- >>>>Using Tomcat but need to do more? Need to support web services, >>>>security? >>>>Get stuff done quickly with pre-integrated technology to make >>>>your job easier >>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>>Geronimo >>>>http://sel.as-us.falkag.net/sel? >>>>cmd=lnk&kid=120709&bid=263057&dat=121642 >>>>_______________________________________________ >>>>Sqlalchemy-users mailing list >>>>Sqlalchemy-users@lists.sourceforge.net >>>>https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users >>> >>> >>> >>> >>>------------------------------------------------------- >>>Using Tomcat but need to do more? Need to support web services, >>>security? >>>Get stuff done quickly with pre-integrated technology to make your >>>job easier >>>Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>Geronimo >>>http://sel.as-us.falkag.net/sel? >>>cmd=lnk&kid=120709&bid=263057&dat=121642 >> >> >>Using Tomcat but need to do more? Need to support web services, >>security? >>Get stuff done quickly with pre-integrated technology to make your >>job easier >>Download IBM WebSphere Application Server v.1.0.1 based on Apache >>Geronimo >>http://sel.as-us.falkag.net/sel? >>cmd=lnk&kid=120709&bid=263057&dat=121642 >>_______________________________________________ >>Sqlalchemy-users mailing list >>Sqlalchemy-users@lists.sourceforge.net >>https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > > > > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
