Subject: Re: Loading plpgsql in postgres
To: Byron Servies <bservies@pacang.com>
From: Hubert Feyrer <hubert@feyrer.de>
List: netbsd-users
Date: 03/04/2004 23:19:10
On Thu, 4 Mar 2004, Byron Servies wrote:
> $ 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

I'm no postgres guru, but on my toy system, it seems to work:

	miyu% createlang -Uvulab --list vulab
	Procedural languages
	 Name | Trusted?
	------+----------
	(0 rows)

	miyu% createlang -Uvulab adf vulab
	createlang: unsupported language "adf"
	Supported languages are plpgsql, pltcl, pltclu, plperl, plperlu, and
	plpython.
	miyu% createlang -Uvulab plpgsql vulab
	miyu% createlang -Uvulab --list vulab
	Procedural languages
	  Name   | Trusted?
	---------+----------
	 plpgsql | t
	(1 row)

That's on 1.6.2/i386 with the following installed:
	postgresql-lib-7.3.1
	postgresql-client-7.3.1
	postgresql-server-7.3.1nb1

Does /usr/pkg/lib/postgresql/plpgsql.so exist on your system?


 - Hubert

-- 
Hubert Feyrer <hubert@feyrer.de>