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@mailman.atnet.at
https://mailman.atnet.at/mailman/listinfo/debian-postgresql