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 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
