Quoting Seref Arikan <serefarikan@xxxxxxxxx>:
On Tue, Sep 23, 2014 at 9:36 AM, Craig Ringer <craig@xxxxxxxxxxxxxxx> wrote:
Hi all
I've had some issues with how the procedural languages are packaged in
the Windows installer for a while, but I was very surprised to see that
plpython2 appears to be entirely absent in 9.3.
It doesn't seem to be provided via EDB's StackBuilder app either.
What's going on? It looks like it was dropped in 9.1.
I've gone through the same journey myself. Tried to juggle dlls etc.[...]
I've struggled with plpython on OpenBSD 5.5-amd64 as well. Could it be
related? Maybe the amount of dependencies python pulls in gets
overwhelming and things break?
$ psql -h localhost -d postgres
psql (9.3.2)
Type "help" for help.
postgres=# create language plpython2u;
ERROR: could not load library
"/usr/local/lib/postgresql/plpython2.so": dlopen
(/usr/local/lib/postgresql/plpython2.so) failed: Cannot load specified
object
postgres=# create language plperl;
CREATE LANGUAGE
postgres=#
This is strange because /usr/local/lib/postgresql/plpython2.so exists.
Also, perl loads fine.
$ ls -l /usr/local/lib/postgresql/pl*
-rwxr-xr-x 1 root bin 100948 Jul 31 02:05
/usr/local/lib/postgresql/plperl.so
-rwxr-xr-x 1 root bin 181287 Jul 31 02:05
/usr/local/lib/postgresql/plpgsql.so
-rwxr-xr-x 1 root bin 137951 Mar 4 12:45
/usr/local/lib/postgresql/plpython2.so
I uninstalled all the postgres subpackages and rebuilt them from
ports, and ended up with an identical plpython2.so, which has these
checksums:
SHA256 (/usr/local/lib/postgresql/plpython2.so) =
8c7ff6358d9bf0db342e3aca1762cd7c509075a6803b240291d60a21ca38198b
MD5 (/usr/local/lib/postgresql/plpython2.so) =
bb6122f27f48f0b3672dbc79cef40eea
SHA1 (/usr/local/lib/postgresql/plpython2.so) =
4dd79641cbad3f71466648559d74e6b0c4f174a3
Any other OpenBSD users that have run into this, here?
--
Nick Guenther
4B Stats/CS
University of Waterloo
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
