RE: [SQL] plpgsql error

From: Michael J Davis <michael(dot)j(dot)davis(at)tvguide(dot)com>
To: "'Adam H(dot) Pendleton'" <apendleton(at)vgsinc(dot)com>, pgsql-sql(at)hub(dot)org
Subject: RE: [SQL] plpgsql error
Date: 1999-05-10 20:46:59
Message-ID: 93C04F1F5173D211A27900105AA8FCFC1454D5@lambic.prevuenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Look in the docs for create language. You need to execute a create language
command to tell postgres to recognize plpgsql. I believe the library is
created as part of the install process.

> -----Original Message-----
> From: Adam H. Pendleton [SMTP:apendleton(at)vgsinc(dot)com]
> Sent: Monday, May 10, 1999 2:32 PM
> To: pgsql-sql(at)hub(dot)org
> Subject: [SQL] plpgsql error
>
> I get this error when I try to create a function using plpgsql:
>
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
> Recognized languages are sql, C, internal and the created procedural
> languages.
>
> Do I need to specify another flag when I compile Postgresql?
>
> Adam
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Si hoc legere scis nimium eruditionis habes.
>
>

Browse pgsql-sql by date

  From Date Subject
Next Message Andy Lewis 1999-05-10 21:05:22 Re: [SQL] plpgsql error
Previous Message Adam H. Pendleton 1999-05-10 20:32:09 plpgsql error