Subject: Loading plpgsql in postgres
To: None <netbsd-users@netbsd.org>
From: Byron Servies <bservies@pacang.com>
List: port-cobalt
Date: 03/04/2004 14:02:01
Hi,

I built postgres from pkgsrc and after adjusting my
kernel parameters it does the basics fine.  Now I
need to add the plpgsql language to it; everything
was built when the database was installed, but
running createlang fails:

$ createlang plpgsql template1
ERROR:  Load of file /usr/pkg/lib/postgresql/plpgsql.so failed: dlopen (/usr/pkg/lib/postgresql/plpgsql.so) not supported
createlang: language installation failed

Browsing through mail archives seems to indicate that
this means the database cannot find the SPI_* functions
(which are, indeed, undefined in the plpgsql.so lib
as expected) and that there may be a problem with
dlopen.

I would like to know if this is a problem specific to
the cobalt port, or if there is a general issue here.

Can others load this language on x86, or other platforms?

Thanks,

Byron