This has been fixed and committed, according to Mike. -G On Wednesday, May 3, 2006, 1:58:40 PM, you wrote: > Hey All,
> I'm running into an interesting problem. There's a quick obvious solution, > but I think it's a placebo, so I want to run this by everyone else first. > In this case (attached .sql creates the necessary schema) I have three > interconnected tables that I'm viewing using reflection. This is my normal > setup which functions without any problems. However, I recently created a > mapper sourcing from a subselect, and discovered an interesting problem crop > up. At one point, the foreign key is being retrieved from the database as > unicode, but is not being converted to a Python string. This causes an 'if > type(...) == str' check to fail, at which point it's expected to be an object > and things fail. If I set convert_unicode=False, I don't have this problem > (but, of course, other things elsewhere fail...) > As an interesting complication, I was unable to reproduce this effect in the > attached test case (pg_mapper_select_working.py) which, as far as I can > determine, almost exactly reproduces the schema generated by pg_audit_pub.sql. > Attached is my system information, but in short I'm running 1368 with the > DISCRETE ON() patch and modula support for PostgreSQL 8.x. > Reproduce this by loading the pg_audit_pub.sql schema into your 'test' > database and executing the pg_audit_pub.py with appropriate credentials. > Hopefully this helps! > Cheers, > -G ------------------------------------------------------- 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