| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | Andreas Tille <tillea(at)rki(dot)de> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 7.1 upgrade problems |
| Date: | 2001-06-08 15:37:28 |
| Message-ID: | 20010608173728.A19370@feivel.credativ.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2001-06-08 15:42:34 | Re: maximum number of rows in table - what about oid limits? |
| Previous Message | Jonathan Bartlett | 2001-06-08 15:31:11 | RE: PostgreSQL 7.1 and ORACLE 8.x |