On Fri, Jun 08, 2001 at 04:37:42PM +0200, Andreas Tille wrote:
> The Debian package of postgresql 7.1 replaces the former extra package
> postgresql-pl and so I guess that plpgsql support is now included in the
> postgresql package. Unfortunately I get
It is.
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
> Recognized languages are sql, C, internal, and created procedural languages.
Could it be that you did not enable plpgsql? The Debian postinst script should
do this for you:
su postgres -c "/usr/lib/postgresql/bin/enable_lang plpgsql --all"
Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!