Hi all, I am trying to upgrade python from 3.7 to 3.8 on my PC with Windows 10 64 bit. The PyGreSQL 5.1 has been installed via pip after the installation of python 3.8.1(python-3.8.1-amd64.exe). ============ >pip install pygresql Collecting pygresql Using cached https://files.pythonhosted.org/packages/be/a8/79a8c03298469e1bdba323eaac63ae521d2d6f8f4c83be17fe93d22c058e/PyGreSQL-5.1.tar.gz Installing collected packages: pygresql Running setup.py install for pygresql ... done Successfully installed pygresql-5.1 ============ But I got an error when trying to import pgdb in Python 3.8, ImportError: DLL load failed while importing _pg: The specified module could not be found. ============ > python Python 3.8.1 (tags/v3.8.1:1b293b6, Dec 18 2019, 23:11:46) [MSC v.1916 64 bit (AMD64)] on win32 Type "help", "copyright", "credits" or "license" for more information. >>> import pgdb Traceback (most recent call last): File "<stdin>", line 1, in <module> File "C:\Program Files\Python38\lib\site-packages\pgdb.py", line 71, in <module> from _pg import * ImportError: DLL load failed while importing _pg: The specified module could not be found. ============ I have tried several ways I see in the internet,
1. Reinstall python 3.8 and PyGreSQL; 2. Set the environment PATH C:\Program Files\PostgreSQL\11\bin\;C:\Program Files\PostgreSQL\11\;C:\Program Files\PostgreSQL\psqlODBC\bin; 3. Reinstall VS build tools(Fix another error while installing pygresql-5.1, "Microsoft Visual C++ 14.0 is required",see https://www.scivision.dev/python-windows-visual-c-14-required/), * Windows 10 SDK * C++ x64/x86 build tools but no luck, still get the same error. The error disapeared only when I switch back to python3.7. What can I do to use PyGreSQL in Python 3.8 , Windows 10 64bit? Thanks in advance!
_______________________________________________ PyGreSQL mailing list PyGreSQL@Vex.Net https://mail.vex.net/mailman/listinfo/pygresql
