I'm attempting to switch from sqlite to postgresql (i want to make use of postgresql's enforcement of foreign key constraints, among other features) and having a tough time getting anywhere with the psycopg2 adapter.
psycopg's website is down and was down the last two times I looked for it over the past month, so I had to find a mirror to download the package. Then it wouldn't install properly (perhaps you've guessed at this point I'm on a Windows box here) -- an error message says the package was compiled with Visual Studio 2003 thus that same compiler would be needed to complete the installation. Download and install Visual Studio 2005 Express (2003 no longer available) but same error persists, no help. Lots of web research later, apparently msys / minGW might be the answer, making it possible to use gcc right in the middle of win32. Carefully and completely installed minGW and its companion packages, slapped together sample program and compiled it successfully: gcc now works on my system; damn I miss 1992 when I first got acquainted with gcc on a SparcStation 1 with a phat 1GB hdd. blah blah blah... hours of tinkering later... still no psycopg2 success. at least setup.py build_ext gets started, but then header files can't be found despite monkeying around with cfg files and other options... the script appears to be telling gcc exactly where to find the postgresql lib files, as verified manually checking thru directories... yet still a half page of error messages at compile time. So i'm scratching my head here. PostgreSQL is a first-class db... and SQLAlchemy is obviously tops... and Psycopg is SQLA's recommended postgreSQL adapter... why is it I can throw four hours or more at it and not get psycopg installed? Any suggestions? I'd like to hear from anyone who made it through a similar hookup successfully. Should have been a pretty straightforward install, I thought. Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---