I fixed this problem for myself, but am posting this in case someone else runs into the same problem, and yeah I realize this is more of a psycopg2 issue.
I was running into a problem where about 1/3 of the time my mac clients failed to import psycopg2, after a call to create_engine(). Which worked most of the time, and all of the time on linux. The error looks like (note my username is dgardner): > db = create_engine (db_uri) > File > "/Library/Python/2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/__init__.py", > > line 160, in create_engine > return strategy.create(*args, **kwargs) > File > "/Library/Python/2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/engine/strategies.py", > > line 62, in create > dbapi = dialect_cls.dbapi(**dbapi_args) > File > "/Library/Python/2.5/site-packages/SQLAlchemy-0.4.5-py2.5.egg/sqlalchemy/databases/postgres.py", > > line 320, in dbapi > import psycopg2 as psycopg > File "build/bdist.macosx-10.5-i386/egg/psycopg2/__init__.py", line 60, in > File "build/bdist.macosx-10.5-i386/egg/psycopg2/_psycopg.py", line 7, in > File "build/bdist.macosx-10.5-i386/egg/psycopg2/_psycopg.py", line 6, > in __bootstrap__ > ImportError: > dlopen(/users/dgardner/.python-eggs/psycopg2-2.0.7-py2.5-macosx-10.5-i386.egg-tmp/psycopg2/_psycopg.so, > > 2): image not found My solution was to install SQLAlchemy and psycopg2 via the mac ports system, and to use the Python 2.5 interpreter from the mac ports system as well. If someone else ran into a similar problem this could go into the FAQ, if no one else has had this problem, then maybe I'm just crazy. -- David Gardner Pipeline Tools Programmer, "Sid the Science Kid" Jim Henson Creature Shop (323) 802-1717 [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---