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