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
