| From: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> |
|---|---|
| To: | Juan Ramón Cortabitarte <jcorta(at)tribctas(dot)gba(dot)gov(dot)ar> |
| Subject: | Re: store procedure in pl/pgsql |
| Date: | 2001-03-02 15:14:31 |
| Message-ID: | 3A9FB8D7.5586A9A0@noaa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Juan Ramón Cortabitarte wrote:
> Hello,
>
> I'm trying to do some store procedure in pl/pgsql but the sql server says
> me:
>
> Error: ERROR: Unrecognized language specified in a CREATE FUNCTION:
> 'plpgsql'. Recognized languages are sql, C, internal and the created
> procedural languages.
>
> I´m using Red Hat Linux 7.0 and Postgress 7.02.
> i executed:
>
> #createlang plpgsql dbhtc
>
> createlang: missing required argument PGLIB directory
createlang --username=postgres --dbname=yourdb --pglib=/usr/lib/pgsql plpgsql
yourdb
If you don't see plpgsql.so in PGLIB directory, then you better re-install
your
PostgreSQL.
| Attachment | Content-Type | Size |
|---|---|---|
| raymond.chui.vcf | text/x-vcard | 414 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Wood | 2001-03-02 15:23:47 | Re: SERIAL values |
| Previous Message | Gregory Wood | 2001-03-02 15:13:08 | Re: serial properties |