search

AbdullahO / tspdb

tspdb: Time Series Predict DB
Apache License 2.0
184 stars 58 forks source link

Best system requirement for tspdb/PSQL/PlPython #16

Open ooo1234567 opened 2 years ago

ooo1234567 commented 2 years ago

Like many others even though I managed to go through the installation process I am not able to make PlPython3u work on Windows 10.

I get a fatal error when I run SELECT test_tspdb(); or when I try to create and use a simple max(int a, int b) function with PlPython3u.

If you managed to make this lib work can you please describe your system setup (OS/PSQL version/ edb version/ Python version...) so I don't lose too much time trying to fix an incompatibility between win10/PlPython.

image

suhanovs commented 2 years ago

It works for me on a Mac (Monterey) with Python 3.9, PostgreSQL 14.2, Language Pack v2.

I had to add double quotes on line 39 of the tspdb--0.0.1.sql script, to enclose "normalize".

330305020 commented 1 year ago

It works for me on a Mac (Monterey) with Python 3.9, PostgreSQL 14.2, Language Pack v2.

I had to add double quotes on line 39 of the tspdb--0.0.1.sql script, to enclose "normalize".

It is also needed in my system: win10, python3.9, postgresql 14.4, language pack v2

jiankunwang6 commented 1 year ago

Hi I'm also having the same issue with 'CREATE EXTENSION plpython3u' on windows. Cannot solve the error :plpython3.dll: The specified module could not be found.

Anyone managed to set up before?