Re: RELEASE: psycopg 2.0.13

On Wed, 7 Oct 2009, Chris Withers wrote:

> Federico Di Gregorio wrote:
>> at least a couple of people wrote me saying 2.0.13 RC 1 was fine and
>> Jason fixed (thank you!) all MSVC problems, 
>
> Still gives the same error message trying to compile on Win32:
>
> C:\Download\psycopg2-2.0.13>\Python26\python.exe setup.py install
> running install
> running build
> running build_py
> creating build
> creating build\lib.win32-2.6
> creating build\lib.win32-2.6\psycopg2
> copying lib\errorcodes.py -> build\lib.win32-2.6\psycopg2
> copying lib\extensions.py -> build\lib.win32-2.6\psycopg2
> copying lib\extras.py -> build\lib.win32-2.6\psycopg2
> copying lib\pool.py -> build\lib.win32-2.6\psycopg2
> copying lib\psycopg1.py -> build\lib.win32-2.6\psycopg2
> copying lib\tz.py -> build\lib.win32-2.6\psycopg2
> copying lib\__init__.py -> build\lib.win32-2.6\psycopg2
> running build_ext
> error: The system cannot find the file specified
>
> What file can't it find? Why not say the name/path of the file in the error 
> message?!

Yeah, pretty descriptive error message.  I believe distutils is just 
passing up an error from the standard libraries and what you are hitting 
is setup.py can not find the pg_config executable to figure out what the 
library and include paths are.  You can define the location to your 
pg_config in setup.cfg.  Thinking about it, one could wrap it in a try 
statement and catch the error.  I'll submit a patch on to give a warning 
if setup.py can't find pg_config.


>> * New features:
>>   - Support for UUID arrays.
>>   - It is now possible to build psycopg linking to a static libpq
>>     library.
>
> How do I do this? Has anyone done this on Windows? Would be great to get a 
> binary egg for Windows that's statically linked up on PyPI...

I believe it goes without saying that I have done it :)

You might need to change a few variables in setup.cfg, too.  The 
pg_config= and have_ssl= are two to look at, and keep in mind the libs and 
include directories, depending on your setup.


> Chris
>
> -- 
> Simplistix - Content Management, Batch Processing & Python Consulting
>           - http://www.simplistix.co.uk


-jason