Re: Where art thou, plpython2.dll? (EDB installer)

Quoting Seref Arikan <serefarikan(at)gmail(dot)com>:
>
> On Tue, Sep 23, 2014 at 9:36 AM, Craig Ringer <craig(at)2ndquadrant(dot)com> 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