Psycopg2 date problems: "Can't adapt"

[mvanier at cs.caltech.edu]

There was a thread a while back dealing with an error message the
psycopg2 Postgres interface gives when trying to convert some
mxDateTime values: "can't adapt".  The answer given was that psycopg2
wasn't finding the mxDateTime include files during setup, so it assumed
they weren't there.  I'm having the same problem.  I've installed both
packages from source.  However, as far as I can tell, the mxDateTime
include files are never copied to the location where psycopg2 expects
them to be (that being /usr/local/include/python2.4/mx on my machine).
Instead, they're scattered throughout
/usr/local/lib/python2.4/site-packages/mx.  I could manually copy them
to where psycopg2 wants them to be, but I shouldn't have to.  I'm using
mxDateTime 2.06, which (although seemingly quite old) appears to be the
most recent version.  Does anyone have any insight into this?

Thanks,

Mike