7.1 upgrade problems

Hello,

I just updated a smaller database with some functions declared

LANGUAGE 'plpgsql';

from 7.0.3 to 7.1 (Debian package 7.1release-4)

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

web=# CREATE FUNCTION changed_at_timestamp ( ) RETURNS opaque AS '
web'# BEGIN
web'# NEW.changedat := now();
web'# RETURN NEW;
web'# END;
web'# ' LANGUAGE 'plpgsql';
ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
Recognized languages are sql, C, internal, and created procedural languages.

I havn't found any hints about special things to do to enable plpgsql. So
is there any reason why this failed?

Kind regards

Andreas.

_______________________________________________
debian-postgresql mailing list
debian-postgresql(at)mailman(dot)atnet(dot)at
https://mailman.atnet.at/mailman/listinfo/debian-postgresql