From: | Andreas Tille <tillea(at)rki(dot)de> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | 7.1 upgrade problems |
Date: | 2001-06-08 14:37:42 |
Message-ID: | Pine.LNX.4.21.0106081635540.1891-100000@wr-linux02 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-08 14:38:02 | Re: maximum number of rows in table - what about oid limits? |
Previous Message | Joseph | 2001-06-08 13:54:17 | storing images in postgres |