patternsqlMinor
Couldn't open extension control file plpython3u.control : No such file or directory
Viewed 0 times
suchdirectoryfilecontrolopenextensionplpython3ucouldn
Problem
I want to have python3 in my postgresql database for writing stored procedures.
Being in the
I have checked, there are plpythonu.control and plpython2u.control in the directory, but not the one for version 3.
However I have installed the packages
What should I install (or do) to have the plpython3u.control file on my machine and have python3 available in my database?
Being in the
psql client, when I enter the command create extension plpython3u I get the error:couldn't open extension control file /usr/share/postgresql/9.1/extension/plpython3u.control : No such file or directoryI have checked, there are plpythonu.control and plpython2u.control in the directory, but not the one for version 3.
However I have installed the packages
python3 and python3-postgresql (among others) from depot. I'm using Ubuntu 12.04, kernel 3.2.0.38, with postgresql 9.1 installed.What should I install (or do) to have the plpython3u.control file on my machine and have python3 available in my database?
Solution
The package to install is
By way of dependencies, this will install
$ dpkg -L postgresql-plpython3-9.1
/.
/usr
/usr/share
/usr/share/doc
/usr/share/doc/postgresql-plpython3-9.1
/usr/share/doc/postgresql-plpython3-9.1/copyright
/usr/share/postgresql
/usr/share/postgresql/9.1
/usr/share/postgresql/9.1/extension
/usr/share/postgresql/9.1/extension/plpython3u--1.0.sql
/usr/share/postgresql/9.1/extension/plpython3u.control
/usr/share/postgresql/9.1/extension/plpython3u--unpackaged--1.0.sql
/usr/lib
/usr/lib/postgresql
/usr/lib/postgresql/9.1
/usr/lib/postgresql/9.1/lib
/usr/lib/postgresql/9.1/lib/plpython3.so
/usr/share/doc/postgresql-plpython3-9.1/changelog.Debian.gz
and then you can do:
postgresql-plpython3.By way of dependencies, this will install
postgresql-plpython3-9.1, which provides these files:$ dpkg -L postgresql-plpython3-9.1
/.
/usr
/usr/share
/usr/share/doc
/usr/share/doc/postgresql-plpython3-9.1
/usr/share/doc/postgresql-plpython3-9.1/copyright
/usr/share/postgresql
/usr/share/postgresql/9.1
/usr/share/postgresql/9.1/extension
/usr/share/postgresql/9.1/extension/plpython3u--1.0.sql
/usr/share/postgresql/9.1/extension/plpython3u.control
/usr/share/postgresql/9.1/extension/plpython3u--unpackaged--1.0.sql
/usr/lib
/usr/lib/postgresql
/usr/lib/postgresql/9.1
/usr/lib/postgresql/9.1/lib
/usr/lib/postgresql/9.1/lib/plpython3.so
/usr/share/doc/postgresql-plpython3-9.1/changelog.Debian.gz
and then you can do:
postgres=# create extension plpython3u;
CREATE EXTENSIONCode Snippets
postgres=# create extension plpython3u;
CREATE EXTENSIONContext
StackExchange Database Administrators Q#37292, answer score: 8
Revisions (0)
No revisions yet.