[PyGreSQL] problem with executable using pgdb

[Christoph Zwerschke]

Gregor Mosheh wrote:
> I have a Python program which uses PyGreSQL, specificallly pgdb, to do
> database stuff. It works perfectly when run in Python, but when compiled
> with py2exe it doesn't work. Instead I get the windows error message of
> "this program encouontered an error..."
> 
> I figured out that it's the pgdb module that's not working for py2exe, and
> can replpicate this problem with this simple program:
> 
> import time
> import pgdb
> time.sleep(10)

I checked it with this and another simple test program printing the 
result of a select statement, and both work fine for me.

What I do is adding the PostgreSQL bin directory (something like 
"C:\Program Files\PostgreSQL\8.2\bin") to the Windows PATH instead of 
copying the PostgreSQL dll's around. Can you try that?

-- Christoph