I take back everything. psycopg 2 installs as psycopg2 so there is no conflict with psycopg. Also SA check to see what's available and prefers psycopg2. All is good.
Randall Randall Smith wrote: > 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 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
