How to get PL languages to work in Postgres

From: Erich <hh(at)cyberpass(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: How to get PL languages to work in Postgres
Date: 2000-07-13 01:18:24
Message-ID: 200007130118.SAA01704@cyberpass.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm sure this is a dumb question, but...

When I try to create a PL/pgSQL function, even a very simple one like
the add_one function in the example, I get this error:

ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Recognized languages are sql, C, internal and the created procedural languages.

Do you have any idea how to get it to work? I just compiled and
installed Postgres in the normal way. I can see that there is a
plpgsql.so in /usr/local/pgsql/lib.

Have I missed an installation option? Anything else I should do?

Thanks,

e

Browse pgsql-general by date

  From Date Subject
Next Message Robert B. Easter 2000-07-13 01:44:04 Re: Triggers with arguments
Previous Message Erich 2000-07-13 01:12:00 Re: Figured it out (psql and Gnu readline)