From: | Peter Crosbie <pjcrosbie(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | postgres 9.5 create function plpthon3u resets connections to server |
Date: | 2016-05-23 14:33:20 |
Message-ID: | CANsU3HjDP+p23TsagKoQf5_8pK0YyNBUxU85pc6S8Jjz_aFzBw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
postgresql 9.5 on windows 10, x64.
I have created the extension plpython3u with python 3.3.5 on the server's
path and it appeared to create the extension successfully:
SELECT * FROM pg_available_extensions
WHERE name like '%python%' order by name;
name | default_version | installed_version |
comment
-------------------+-----------------+-------------------+------------------------------------------
-
hstore_plpython2u | 1.0 | | transform
between hstore and plpython2u
hstore_plpython3u | 1.0 | | transform
between hstore and plpython3u
hstore_plpythonu | 1.0 | | transform
between hstore and plpythonu
ltree_plpython2u | 1.0 | | transform
between ltree and plpython2u
ltree_plpython3u | 1.0 | | transform
between ltree and plpython3u
ltree_plpythonu | 1.0 | | transform
between ltree and plpythonu
plpython2u | 1.0 | | PL/Python2U
untrusted procedural language
plpython3u | 1.0 | 1.0 | PL/Python3U
untrusted procedural language
plpythonu | 1.0 | | PL/PythonU
untrusted procedural language
(9 rows)
However when I attempt to create the following function (from the pg docs
<http://www.postgresql.org/docs/9.5/static/plpython-funcs.html>)
CREATE FUNCTION pymax (a integer, b integer)
RETURNS integer
AS $$
if a > b:
return a
return b
$$ LANGUAGE plpython3u;
the psql (or pgadmin3) terminal's connection is reset.
The python 3.3 on the path is anaconda's distb and runs fine on its own. I
couldn't find the required version of python in the postgresql docs and
used dependency walker as described here Postgres database crash when
installing plpython
<http://stackoverflow.com/questions/12010344/postgres-database-crash-when-installing-plpython?rq=1>
to
find the required dll that plpython3.dll in the server's lib/ requires.
Can anyone help me with what I have missed?
This question is also posted on stackoverflow here
<https://stackoverflow.com/questions/37382511/postgres-9-5-create-function-plpthon3u-resets-connections-to-server>
.
Thanks in advance for your help.
Many thanks
From | Date | Subject | |
---|---|---|---|
Next Message | JORGE MALDONADO | 2016-06-10 02:24:46 | Permission Denied when trying to create a Tablespace in Windows |
Previous Message | neha khatri | 2016-05-17 23:17:30 | Re: Crash recovery after dropdb crash |